468,257 Members | 1,441 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

Unicode...

DB2 UDB 8.2 / AIX 5.3

I had asked a few questions previously about this and did not receive
any response. Are there any unicode users out there that might know
the answers to these two questions:

1) Is it necessary to use the SQLConnectW() (CLI APIs) to connect to
the database?

I am prototyping a change where we are changing a set of existing
tables from ASCII to Unicode. I am able to run ok using the regular
connect. I do not see any issues with the CHAR and VARCHAR fields in
the table. I turned on Japanese locale settings on the machine and
had a coworker insert some characters in those fields...it seems to
display ok. I believe Japanese uses 2-byte characters so if there was
an issue I would think it would but garbage in those columns.

When I originally set up the test I didnt see anything that referred
to using SQLConnectW in the DB2 information I was reading. I ran
across it several days later while researching some other questions I
had and was worried I might be missing something.

Does anyone know if SQLConnectW is only used in certain instances or
if I am going to have issues later on for not using it?

2) Do I need to change the DB2CODEPAGE to 1208 (or something that
supports all utf-8?

Again, it did not specify to do this in the write ups I found but I
also read some information about setting the code pages. Also, as I
said above, my prototype is working and I have not changed it from the
default English (though I tried and someone here was nice enough to
tell me that you cannot change it once it is setup).

So..question #2 is it necessary to change the CODEPAGE?
Thanks in advance!

Aug 7 '07 #1
0 1226

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Michael Weir | last post: by
8 posts views Thread by Bill Eldridge | last post: by
8 posts views Thread by Francis Girard | last post: by
4 posts views Thread by webdev | last post: by
2 posts views Thread by Neil Schemenauer | last post: by
10 posts views Thread by Nikolay Petrov | last post: by
6 posts views Thread by Jeff | last post: by
13 posts views Thread by Tomás | last post: by
24 posts views Thread by ChaosKCW | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.