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.