Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: DB2 set encoding to UTF-8 after database is created

    It is possible to change the encoding of database content after it is created?

    I need to put special characters into some fields (like č or ť) and the default encoding is not working right (when working with DB2 control center).

    Database is already created... how can I change it?

    DB2 version that I'm using is 9.7.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    See if alt_collate database parameter helps. You have to use ccsid in the create table.

    Otherwise, all parameters that define encoding are informational and cannot be changed.

    Database territory = US
    Database code page = 1208
    Database code set = UTF-8
    Database country/region code = 1
    Database collating sequence = IDENTITY
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by SoG.Hawking View Post
    the default encoding is not working right (when working with DB2 control center).
    Are you sure it's the database and not the client?
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Mar 2013
    Posts
    2
    Quote Originally Posted by n_i View Post
    Are you sure it's the database and not the client?
    Yes, I was sure...


    Thanks, but the alternate collation was not the right solution for me, I recreated the database and moved the tables and schemas (which, however, was also an issue - I used db2move, but not a single command in DB2 works the right way).

    Long live the DB2.

    You can close this thread.

Posting Permissions

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