X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 55231D1EDD7 for ; Fri, 7 May 2004 08:50:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33306-06 for ; Fri, 7 May 2004 08:50:32 -0300 (ADT) Received: from barok.foi.hr (barok.foi.hr [161.53.120.3]) by svr1.postgresql.org (Postfix) with ESMTP id 7CA03D1E632 for ; Fri, 7 May 2004 08:50:27 -0300 (ADT) Received: from krabuzin (k177.prof.foi.hr [192.168.3.177]) by barok.foi.hr (8.12.10/8.12.10) with SMTP id i47BoRv0026241 for ; Fri, 7 May 2004 13:50:29 +0200 (MEST) Message-ID: <006101c43429$a7b24c40$b103a8c0@krabuzin> From: "Kornelije" To: Subject: SELECT - ORDER BY Croatian characters .... Date: Fri, 7 May 2004 13:51:32 +0200 Organization: FOI MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005E_01C4343A.67D730C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200405/72 X-Sequence-Number: 17786 This is a multi-part message in MIME format. ------=_NextPart_000_005E_01C4343A.67D730C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi everybody, I'm using PostgreSQL and my database contains Croatian Characters (ccz...).= ... so when I pose a query, and I use order by clause, the result is not sorted= properly..... I was using once VB for aplications and there I've used a function which ch= anged Croatian characters with some equivalents and sorting order was ok; s= ince now I'm using PHP, is it feasible to write such a function or is there= a better solution? thanks Kornelije ------=_NextPart_000_005E_01C4343A.67D730C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi everybody,

I'm using PostgreSQL and my database conta= ins=20 Croatian Characters (čć=9E...)....

so when I pose a query, and I use order by= clause,=20 the result is not sorted properly.....

I was using once VB for aplications a= nd=20 there I've used a function which changed Croatian characters with some= =20 equivalents and sorting order was ok; since now I'm using PHP, is it= =20 feasible to write such a function or is there a better solution?

thanks

Kornelije

------=_NextPart_000_005E_01C4343A.67D730C0--