|
|
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.
| |