Hi there,

I need to connect to a DB2 database, which is required to be UNICODE
enabled. Usually, it is created like this:

db2 CREATE DATABASE testdb USING CODESET UTF-8 TERRITORY us

Unfortunately, it is not me, who creates the database. I have to rely on
the database admins to create it correctly.

Now, I would like to verify the database settings. Is there another way
than putting UNICODE encoded strings into a test table and query them
afterwards to see, whether the strings are still the same?

I looked through the SQL Reference Appendix D, where the catalog views
are described... I did not find any related view.

JDBC database metadata does not give me any evidence either.

If you can give me an advice, I would greatly appreciate it.

Thanks,

Johannes

DB2 & UDB email list listserv db2-l LazyDBA home page