467,887 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

UDB sort sequence problem

Hi,
I created database using
CREATE DATABASE TEST ON D: USING CODESET 1250 TERRITORY HR COLLATE
USING
SYSTEM

in order to sort national specific characters in right order. But this
still doesn't work. Characters are inserted and displayed correctly,
but
the sort order is wrong.

I'm doing something wrong?

I'm using IBM UDB v7.2 on Windows.

Any help appreciated.

Filip

Mar 9 '06 #1
  • viewed: 1365
Share:
3 Replies
Ian
I tested this on DB2 v7.2 and V8, and the sort order is definitely
wrong for one of Croatian letters. I fixed this with custom collation
but I think it should work correctly by default.

Mar 28 '06 #2
Ian wrote:
I tested this on DB2 v7.2 and V8, and the sort order is definitely
wrong for one of Croatian letters. I fixed this with custom collation
but I think it should work correctly by default.

Hi!

Yes, it is wrong. I'm from Slovenia and we have the same problem.
None of the Central Europe languages are correctly sorted :((( by default.
Let's hope that future DB2 versions will correct this.

Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Mar 29 '06 #3
Gregor KovaÄŤ wrote:
Ian wrote:
I tested this on DB2 v7.2 and V8, and the sort order is definitely
wrong for one of Croatian letters. I fixed this with custom collation
but I think it should work correctly by default.

Hi!

Yes, it is wrong. I'm from Slovenia and we have the same problem.
None of the Central Europe languages are correctly sorted :((( by default.
Let's hope that future DB2 versions will correct this.


Have you opened a PMR to get let the developers know about it?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Brian McGonigle | last post: by
7 posts views Thread by Ireneusz SZCZESNIAK | last post: by
20 posts views Thread by Xah Lee | last post: by
1 post views Thread by (PeteCresswell) | last post: by
10 posts views Thread by Anton Vredegoor | last post: by
reply views Thread by JosAH | last post: by
1 post views Thread by Ronald S. Cook | last post: by
1 post views Thread by James Hahn | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.