Received: from field.videotron.net (field.videotron.net [205.151.222.108]) by hub.org (8.10.1/8.10.1) with ESMTP id e67ITBW95234 for ; Fri, 7 Jul 2000 14:29:11 -0400 (EDT) Received: from inter-resa.com ([24.200.227.43]) by field.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FXC0058OB7ZWX@field.videotron.net> for pgsql-sql@postgresql.org; Fri, 7 Jul 2000 14:26:23 -0400 (EDT) Date: Fri, 07 Jul 2000 14:23:22 -0400 From: Web Manager Subject: Re: order by accents? To: pgsql-sql@postgresql.org Cc: Patrick Coulombe Message-id: <3966201A.DC33D183@inter-resa.com> Organization: INTER-Res@ tourism network MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.12 i386) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 8BIT X-Accept-Language: en References: <39660B1F.CD9B9EF2@mediacces.com> X-Archive-Number: 200007/84 Patrick Coulombe wrote: > > hi, > if I do a query like this one : > > SELECT name from medias ORDER BY name > > name > ---- > AAAA > CCCC > EEEE > VVVV > ZZZZ > ÉCCC > ---- > 6 rows > > Why the record : ÉCCC is at the end? > HOW can I fix this? > > Thank you > Patrick Hello, I have the same problem (the character is not recognized - we also use french) and it seems that the only way around this "bug" is to install Postgres with a local package... but many told me that is was slower and not very useful... I did not try it. Instead, we plan to create a second column with same french data but without accents... The query will be based on that field for the order by needs... not great, but I will do exactly what we expect and no add-ons. Hope this helps! Bonne journée! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Marc Andre Paquin