[BUGS] BUG #2264: bad work with cyrillic encoding -
02-15-2006
, 10:50 AM
The following bug has been logged online:
Bug reference: 2264
Logged by: Alex Kostyshin
Email address: root (AT) ulif (DOT) org.ua
PostgreSQL version: 8.1.x
Operating system: Windows XP/SP2, Windows XP x64
Description: bad work with cyrillic encoding
Details:
1. Wrong sorting order: not A,a,B,b, etc for cyrillic texts, but
A,B,...,a,b..
String functions do not work with cyrillic arguments, for example:
Latin:
Select lower('Tom')
lower
--------
tom
1 record(s) selected [Fetch MetaData: 31/ms] [Fetch Data: 0/ms]
Cyrillic:
Select lower('Алекс')
lower
--------
Алекс
1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |