store kannada characters in db2 database

pratapd · #1 (**permalink**) 03-17-11, 12:29

Hello,

Could some one let me know how to store kannada characters in db2 database ?

I am using db2 v9.1 fp10 on windows machine.

Thanks,
Pratapd

Marcus_A · #2 (**permalink**) 03-17-11, 12:59

You need use UTF-8 when the database is created. Check the db cfg and see what the value of "Database code set." Once the database is created, it cannot be changed.

You can search for DBCS (double byte character set) in DB2 for more information.

pratapd · #3 (**permalink**) 03-17-11, 13:07

thanks for the quick reply!!
Yes.. I did create a UTF-8 database.
But I am unable to copy kannada characters on to my db2 command window for inserting rows into my table.. any idea how to do this on a windows machine ?

Regards,
Pratapd

nvk@vhv · #4 (**permalink**) 03-18-11, 03:54

Hi,

what error messages do you get?
If you create a table with char(10) it can store 10 bytes. UTF-8 Characters may use two or more Bytes. So you may need to create larger textfields.

Cheers,
nvk