473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
3 1507
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Brian McGonigle | last post by:
I'm a Perl programmer learning Python (up to chapter 7 in Learning Python, so go easy on me :-) and I find that I look to do things in Python the way I would do them in Perl. In Perl functions and...
7
by: Ireneusz SZCZESNIAK | last post by:
I want to sort a vector with the std::sort function. There are two functions: one with two arguments, the other with three arguments. I am using the one with three arguments. I noticed that...
20
by: Xah Lee | last post by:
Sort a List Xah Lee, 200510 In this page, we show how to sort a list in Python & Perl and also discuss some math of sort. To sort a list in Python, use the “sort” method. For example: ...
14
by: amywolfie | last post by:
Hi All: I know this is simple, but I just can't seem to get there: I need to sort a table by a text field (txtDescription), then assign sequential numbers to the field SEQUENCE in table. ...
1
by: (PeteCresswell) | last post by:
I'm loading a TreeView control from a recordset that's sequenced by a date. When I step through the code, I *think* I'm seeing the nodes created in the expected sequence. Problem is, when the...
10
by: Anton Vredegoor | last post by:
Python's sorting algorithm takes advantage of preexisting order in a sequence: #sort_test.py import random import time def test(): n = 1000 k = 2**28
0
by: JosAH | last post by:
Greetings, I was asked to write a Tip Of the Week; so here goes: a lot of topics are started here in this forum (and a lot of other forums too) mentioning a problem about sorting data. ...
0
by: Amar | last post by:
Hi, I have a generic list with a some objects of a particular class in it. I have implemented a IComparer for the the class and pass it to the List. The list.sort method works fine when the value...
1
by: Ronald S. Cook | last post by:
I have a DataTable with column "Sequence". Values are like: Sequence -------- 5 1 3 (blank/null) 7 6
1
by: James Hahn | last post by:
I have a ListView that displays files selected from various folders using a user-specified selection rule. I want to sort the files in various ways and have implemented a sorter class to do it,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.