 |
 |
Archives of the TeradataForum
Message Posted: Tue, 24 Jul 2012 @ 09:34:01 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.
| |
