Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: character set and sort order for new database

    We are using ver 8.1 in solaris 5.8
    how to find out the Character Set and also the Sort Order?

    Also what are default values for them when we create the database.

    Thanks in advance,
    toby

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2 get db cfg for <dbname>
    and you will find codepage, collating seq etc for the database.
    You can start from http://publib.boulder.ibm.com/infoce...n/c0004123.htm
    for information.
    The default values are picked up from the Operating system's locale settings. On Unix System's, locale values can be obtained by using the command 'locale'
    Quote Originally Posted by toby25
    We are using ver 8.1 in solaris 5.8
    how to find out the Character Set and also the Sort Order?



    Also what are default values for them when we create the database.




    Thanks in advance,
    toby
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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