All Forums Tools
piotrs 10 posts Joined 08/09
10 Dec 2009
How is it possible to view Unicode data?

I'm writing application, which i.a. inserts Unicode strings into Teradata. I don't know how I can see inserted data, to check wheter it was inserted properly. SQL Assitant doesn't support Unicode, I tried in BTEQ command EXPORT DATA FILE=..., but it wrote to file only strange symbols not in Unicode... is it possible to preview Unicode strings, which are in Teradata DB?

Jimm 298 posts Joined 09/07
16 Dec 2009

Set the Session Character set to UTF8 or UTF16 before running your export.
You then have to view the file in hex - I use Ultraedit but any hex viewer will do.

You must sign in to leave a comment.