ENCODING Error in Teradata v14

Database

ENCODING Error in Teradata v14

Hi,

I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query.

SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),'base16'),'base10') AS INT)) AS col_A_dec FROM table_a

I am trying to run the following query on Teradata 14. However, I am getting error as "Unsupported ENCODING Type".

The same query runs fine when I login to another database.

Please let me know if there is something I am missing.

Thanks,

Aarsh

1 REPLY

Re: ENCODING Error in Teradata v14

Additionally, the database on which it fails has the below characteristics:

RELEASE    14.00.03.08

VERSION    14.00.03.07

LANGUAGE SUPPORT MODE    Standard

The database on which it works has the below characteristics:

RELEASE    14.00.04.01

VERSION    14.00.04.01

LANGUAGE SUPPORT MODE    Standard

Is there a way to make sure the query runs on former database as well?