Thread: BUG #1788: charset of sorting bug

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 ??

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