Archives of the TeradataForum
Message Posted: Tue, 24 Jul 2012 @ 09:20:21 GMT
| Subj: || || Re: Purpose of TRANSLATE command? |
| From: || || Pluebell, Fred |
The TRANSLATE function converts a character string from one server character set to another server character set. This conversion, whether
explicit in the submitted SQL or implicitly inserted as the query is parsed & optimized, is necessary to support proper string comparison.
And this is separate from any translation between server character set and client character set.