Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    4

    Unanswered: choosing a collating sequence at query time

    Hello everybody,

    we are running DB2 UDB v8.1.7.445 on Win2K with a database set to the following settings:

    Codepage: -
    Codeset: UTF-8
    Country: 49
    Territory: DE

    If I order a result set it is sorted by 0-9A-Z. Is there any possibility to change that sort order at query time? Or, if the sort behaviour is only choosable at database creation time, what can I do now?

    Thx for your help in advance!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by major.tom
    Is there any possibility to change that sort order at query time?

    No, I don't think there is.

    Quote Originally Posted by major.tom
    if the sort behaviour is only choosable at database creation time, what can I do now?
    Sort in the client application

Posting Permissions

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