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

    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 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.


  2. #2
    Join Date
    Jun 2006
    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
    Jena, Germany
    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