Thread: beta2 guru hints misidentifies server OS

beta2 guru hints misidentifies server OS

From
Oriza Triznyák
Date:
Hi All,

Beta2 Guru Hints says:

### QUOTE BEGINS
Unicode encoding on a Win32 server
The database XXXXXX is created to use Unicode (UTF8) encoding to store
data and is operated on a PostgreSQL 8.0 server running on a Win32
server.
The PostgreSQL 8.0 Win32 implementation is not able to sort character
strings according to appropriate collation sequences, because the
operating system doesn't offer sufficient support for this.
For this installation, it is recommended to use a locale specific
encoding, run the cluster on a different operating system or upgrade
your database cluster to PostgreSQL 8.1 which has additional code to
deal with unicode collations to solve the issue.
### QUOTE ENDS

It is definitely wrong in saying it's a Win32 server.
It's a debian linux server.
Just thought the info may be of use.

dueyduey


Re: beta2 guru hints misidentifies server OS

From
Andreas Pflug
Date:
Oriza Triznyák wrote:
> Hi All,
> 
> Beta2 Guru Hints says:
> 
> ### QUOTE BEGINS
> Unicode encoding on a Win32 server
> The database XXXXXX is created to use Unicode (UTF8) encoding to store
> data and is operated on a PostgreSQL 8.0 server running on a Win32
> server.
> The PostgreSQL 8.0 Win32 implementation is not able to sort character
> strings according to appropriate collation sequences, because the
> operating system doesn't offer sufficient support for this.
> For this installation, it is recommended to use a locale specific
> encoding, run the cluster on a different operating system or upgrade
> your database cluster to PostgreSQL 8.1 which has additional code to
> deal with unicode collations to solve the issue.
> ### QUOTE ENDS
> 
> It is definitely wrong in saying it's a Win32 server.
> It's a debian linux server.
> Just thought the info may be of use.

I fixed the code in svn, please check it out. If the problem persists, 
please post the complete string returned from SELECT version().

Regards,
Andreas