CODEWITHSUNDEEP
sqlteradatacollation
Bob
Bob

Reputation: 756

Translating Unicode to Latin in Teradata

In SQL Server you can convert Unicode character sets into Latin character sets by using

CAST(src COLLATE SQL_Latin1_General_CP850_BIN2 AS VARCHAR(255))

However the collate function does not exist in Teradata, I know you can use collation to set the session character display, but how would I translate the character č -> c?

Upvotes: 1

Views: 9944

Answers (1)

Andrew
Andrew

Reputation: 8758

You would use TRANSLATE (<your column> using UNICODE_TO_LATIN). I don't think all unicode characters will be able to be converted to latin though.

Upvotes: 4

Related Questions