Toad World® Forums

TDP Character Conversion Error

I'm running a script in SQL Assistant against Teradata without any errors and when I run the same script in TDP I encounter the following in the SQL editor.

Teradata exception: [Teradata Database] [3704] ' ' ('C2A0'X) is not a valid Teradata SQL token.

The issue is with the case statement.

If the value of the column is output without the use of the case statement it runs fine so somehow TDP appears to be interpreting or converting something incorrectly since the same script will run in another client without fail. The physical values that are stored in the table do not appear to have any problems either so it's unclear what is happening.

Found a solution. This appears to be specific to Teradata, but using an ODBC connection with the Enable Legacy Parser appears to solve the problem.