Re: Turkish character sorting on PostgreSQL

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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQFHakeSldnAQVacBcgRAqLdAJ9D9V4jzyqrZprh2bZkLz3A8rZqwgCdF28G
uXG1sG3Ell5APk953LdgcaU=
=8VQB
-----END PGP SIGNATURE-----