Received: from field.videotron.net (field.videotron.net [205.151.222.108]) by hub.org (8.10.1/8.10.1) with ESMTP id e67GuWW77986 for ; Fri, 7 Jul 2000 12:56:32 -0400 (EDT) Received: from mediacces.com ([24.200.96.79]) by field.videotron.net (Sun Internet Mail Server sims.3.5.1999.12.14.10.29.p8) with ESMTP id <0FXC00D1E6XPOS@field.videotron.net> for pgsql-sql@postgresql.org; Fri, 7 Jul 2000 12:53:49 -0400 (EDT) Date: Fri, 07 Jul 2000 12:53:51 -0400 From: Patrick Coulombe Subject: order by accents? To: pgsql-sql@postgresql.org Message-id: <39660B1F.CD9B9EF2@mediacces.com> MIME-version: 1.0 X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 8BIT X-Accept-Language: en X-Archive-Number: 200007/79 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