How is it possible to view Unicode data?

Tools
Enthusiast

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?
Tags (1)
1 REPLY
Enthusiast

Re: How is it possible to view Unicode data?

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.