|
|
Archives of the TeradataForum
Message Posted: Thu, 28 Feb 2008 @ 16:38:47 GMT
Subj: | | Re: FastExport and UTF8 translation of SQL |
|
From: | | Geoffrey Rommel |
Sorry, I just thought of something.
| We already tried the HEX code for this symbol ('AC'xc) which does turn up the symbol, but also adds some other garbage in the file. | |
The literal 'AC'xc is already a Unicode character, so it should be exported to a UTF-8 file as x'C2AC'. The extra x'C2' is probably the
"garbage" you're seeing. In other words, the delimiter you wanted is there; it's just taking up two bytes.
If you must have a one-byte delimiter, perhaps ~ or ' or a low-order character such as x'1F' would serve.
| |