Date: Thu, 20 Dec 2007 11:44:34 +0100 From: Ivan Voras <ivoras@freebsd.org> To: freebsd-database@freebsd.org Cc: freebsd-questions@freebsd.org Subject: Re: Turkish character sorting on PostgreSQL Message-ID: <fkdh2i$vsu$1@ger.gmane.org> In-Reply-To: <1605513356.20071219221424@EnderUNIX.org> References: <1605513356.20071219221424@EnderUNIX.org>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] 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. [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHakeSldnAQVacBcgRAqLdAJ9D9V4jzyqrZprh2bZkLz3A8rZqwgCdF28G uXG1sG3Ell5APk953LdgcaU= =8VQB -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fkdh2i$vsu$1>