Charset UTF8 with collate UNICODE: ORDER BY works wrong for polish characters
-----------------------------------------------------------------------------
Key: CORE-3738
URL: http://tracker.firebirdsql.org/browse/CORE-3738
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.1, 2.1.4, 2.5.0
Environment: Windows VISTA 32-bit
Reporter: Mariusz Nogala
I have a varchar column defined as charset UTF8 with collate UNICODE.
When I use ORDER BY the result set is:
a, ą, ąb, ac
and should be:
a, ac, ą, ąb
The problem is with the polish 'ą' character. It should just follow the ascii
'a' character.
So why the 'ac' text is older than 'ą' or 'ąb' in the ORDER BY ??? If you sort
single character texts
there is no problem (as seen in the above example: 'ą' follows 'a').
The same problem is with other polish characters: ć, ś, ę, ń, ó, ż, ź.
They should just follow: c, s, e, n, o, z respectively.
For example:
ORDER BY gives:
s, ś, śb, sc
and should be:
s, sc, ś, śb
What is also strange: there is no problem with the polish characters: 'Ł' and
'ł'.
They correctly always follow: 'L' and 'l' respectively.
Summarizing:
I think that charset UTF8 with collate UNICODE should work with
polish characters in the same way as charset WIN1250 with collate pxw_plk.
System Windows also works in this way.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
