PostgreSQL Bugs - BUG #1788: charset of sorting bug

Author

BUG #1788: charset of sorting bug

lunter

2005-07-26, 9:24 am

The following bug has been logged online:

Bug reference: 1788
Logged by: lunter
Email address: lunter@interia.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

Richard Huxton

2005-07-27, 3:26 am

lunter wrote:
> 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

Sponsored Links