Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    23

    Unanswered: Using COLLATE or CHARACTER SET with db2

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    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.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •