Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: how to get list of supported character sets by querying the database

    Database: DB2 V8.1 ESE
    newbie question for learning: How do I get a list of all the character sets the current database can be set to, by querying the database (not from documentation).

    For example, I can get this info from oracle and sybase databases as follows:
    oracle> select value from x$ksulv where parameter='CHARACTERSET';
    sybase> select name from master..syscharsets

    Is there a similar way to do it in DB2 also?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    The DB2 database character set is defined at the database creation time and cannot be changed afterwards. To see with what character set the database has been created use "get db cfg for <db name>"

Posting Permissions

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