Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id 8C8014763FE for ; Mon, 15 Apr 2002 02:40:07 -0400 (EDT) Received: from jac (bri4-56k-206.tpgi.com.au [202.7.185.206]) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g3F6e5p23445; Mon, 15 Apr 2002 16:40:05 +1000 Message-ID: <001301c1e448$609a7cc0$1400a8c0@jac> From: "jack" To: , "Josh Berkus" References: Subject: Re: data order problem Date: Mon, 15 Apr 2002 16:40:03 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/174 X-Sequence-Number: 7438 Hi, Jose Suppose '_' stands for a space character. The one column table,xxx, contains following data. column name is suburb and is set as primary key. 'THE_AAA' 'THE_BBB' 'THE_CDD' 'THECCC' After I do "SELECT * FROM xxx ORDER BY suburb;" I've got this. 'THE_AAA' 'THE_BBB' 'THECCC' 'THE_CDD' But I expect it should be like ... 'THE_AAA' 'THE_BBB' 'THE_CDD' 'THECCC' Because, according to ascii code, space character should be smaller than 'C' ----- Original Message ----- From: "Josh Berkus" To: "jack" ; Sent: Monday, April 15, 2002 2:53 PM Subject: Re: [SQL] data order problem > Jack, > > > why is it not ordered by ASCII sequence. And I found if I put in a > > data such > > as '', it goes to last one when you do the same query. > > I'm sorry, you're going to have to be more explicit. I don't > understand what problem you are having with the order given. > > -Josh Berkus >