dbTalk Databases Forums  

[BUGS] BUG #1788: charset of sorting bug

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


Discuss [BUGS] BUG #1788: charset of sorting bug in the mailing.database.pgsql-bugs forum.



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

Default [BUGS] BUG #1788: charset of sorting bug - 07-26-2005 , 08:28 AM







The following bug has been logged online:

Bug reference: 1788
Logged by: lunter
Email address: lunter (AT) interia (DOT) pl
PostgreSQL version: 8.0.3
Operating system: WinXP SP2 PL
Description: charset of sorting bug
Details:

My system is WinXP SP2 PL (charset WIN-1250)

PG 8.0.3 sort records only with use of charset WIN-1250.
But base encoding is ISO-8859-2 or UTF-8.

How to coerce sorting charset same encoding of database ??

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote
  #2  
Old   
Richard Huxton
 
Posts: n/a

Default Re: [BUGS] BUG #1788: charset of sorting bug - 07-27-2005 , 02:49 AM






lunter wrote:
Quote:
Bug reference: 1788
Operating system: WinXP SP2 PL

My system is WinXP SP2 PL (charset WIN-1250)

PG 8.0.3 sort records only with use of charset WIN-1250.
But base encoding is ISO-8859-2 or UTF-8.

How to coerce sorting charset same encoding of database ??
Locale controls sorting, not encoding. See the manuals/mailing list
archives for details and discussion.

I don't believe PG supports unicode (UTF-8) on Windows fully. Check the
manuals for details.

HTH
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


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.