Archives of the TeradataForum
Message Posted: Tue, 29 Jun 2004 @ 13:30:07 GMT
You weren't very explicit in stating what your problem was.
If you use TRANSLATE(MyColumn USING Unicode_TO_Latin) you will get an error if you are going to lose data. If you don't care about losing data you can use the WITH ERROR option.
There's also a TRANSLATE_CHK function so that you could see which rows will return an error and which won't.
This is all documented in the SQL Reference - Volume 5 Functions and Operators Manual.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|