Archives of the TeradataForum
Message Posted: Thu, 28 Feb 2008 @ 15:15:38 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.|| |
Selecting 'AC'xc does result in a 1-character Unicode string, which is what you want. I think the "garbage" is actually the UTF-8
representation, namely x'C2AC'. That's the delimiter you want; it just happens to take up two bytes.
If you must have a one-byte delimiter, perhaps ~ or ' or a low-order byte such as x'1F' would do the trick.