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
This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2D5D61E373CCE333278A2402 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Ismail YENIGUL wrote: > Hello, >=20 > 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: >=20 > initdb -E UNICODE --locale=3Dtr_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. --------------enig2D5D61E373CCE333278A2402 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHakeSldnAQVacBcgRAqLdAJ9D9V4jzyqrZprh2bZkLz3A8rZqwgCdF28G uXG1sG3Ell5APk953LdgcaU= =8VQB -----END PGP SIGNATURE----- --------------enig2D5D61E373CCE333278A2402--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?fkdh2i$vsu$1>