Turkish character sorting on PostgreSQL

[Ivan Voras]

Ismail YENIGUL wrote:
> Hello,
> 
> I am using PostgreSQL 8.2.5 on FreeBSD 6.2. But I have a problem with
> sorting Turkish characters. They are listed after "z" character.
> I initialized the PostgreSQL with the following values:
> 
> initdb -E UNICODE --locale=tr_TR.UTF-8 and

Unicode (UTF-8) collations (sorting) don't work on FreeBSD. You can use
PostgreSQL 8.1 and the "ICU" patch for it.

> initdb -E LATIN5 --locale tr_TR.ISO8859-9

This could work, if the locale is properly defined in the system locale
database. Try creating a small C program that sorts your strings using
strcoll() to verify this - if the small C program works, it's a
PostgreSQL problem.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 194 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-database/attachments/20071220/3481772b/signature.pgp