I'm using MySQL database for my system current,
now i want to move it to DB2

when i create tables,
i usually put..like example:
create table account(
username varchar(50) character set latin1 default NULL,
password varchar(50) collate latin1_general_cs default NULL
)

something like that, but it doesnt seems to work at db2
do anyone knows how to convert those statement into db2 format?

i've read some articles about CCSID for db2, but it doesnt seems to work.

thanks

collating sequence is defined with create database
you can not specify this for a table
the table is created in the character set of the client. This is for translate purpose if the database is a different charset, so data is returned correctly to the client.

Just throwing something in: as soon as you start unioning data from various tables and also throw in constants or data from external sources, you will quickly run into problems with column-specific collations.