dbTalk Databases Forums  

[BUGS] BUG #2264: bad work with cyrillic encoding

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2264: bad work with cyrillic encoding in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Alex Kostyshin
 
Posts: n/a

Default [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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.