X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0DD4F533CF for ; Mon, 11 Apr 2005 13:41:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88922-06 for ; Mon, 11 Apr 2005 16:41:29 +0000 (GMT) Received: from loncoche.terra.com.br (loncoche.terra.com.br [200.154.55.229]) by svr1.postgresql.org (Postfix) with ESMTP id C8126536C2 for ; Mon, 11 Apr 2005 13:41:27 -0300 (ADT) Received: from talara.terra.com.br (talara.terra.com.br [200.154.55.136]) by loncoche.terra.com.br (Postfix) with ESMTP id 10FE6E78E2A; Mon, 11 Apr 2005 13:41:26 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: da0a5c402cc6a7cf1e4240fa508dc283 Received-SPF: pass (talara.terra.com.br: domain of terra.com.br designates 200.154.55.136 as permitted sender) client-ip=200.154.55.136; envelope-from=reuly@terra.com.br; helo=reuly; Received: from reuly (200-138-202-089.bnut37001.e.brasiltelecom.net.br [200.138.202.89]) (authenticated user reuly) by talara.terra.com.br (Postfix) with ESMTP id C728E14C013; Mon, 11 Apr 2005 13:41:23 -0300 (BRT) Message-ID: <008701c53eb5$8d87d820$5c00a8c0@intranet.tecmicro.com.br> From: =?iso-8859-1?Q?Reuly_B=FAssolo_Mendes?= To: "Stephan Szabo" Cc: References: <00b001c53e98$8c84c630$5c00a8c0@intranet.tecmicro.com.br> <20050411080350.I28912@megazone.bigpanda.com> Subject: Re: Problem in order by Date: Mon, 11 Apr 2005 13:43:10 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.88 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200504/140 X-Sequence-Number: 17153 Hi Stephan, tks I drop database and move directory data to data01. I already executed "initdb --locale=C" and the file postgresql.conf change to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem persist. I already executed too after move the directory data: initdb --encoding=LATIN1 --locale=C initdb --encoding=SQL_ASCII --locale=C Somebody have more any ideia? Tks ----- Original Message ----- From: "Stephan Szabo" To: "Reuly Bússolo Mendes" Cc: Sent: Monday, April 11, 2005 12:05 PM Subject: Re: [ADMIN] Problem in order by On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote: > In the Cygwin, the return is correct: > > prodes > ---------------------------------------------------- > TELHA FRANCESA CAMBORIU > TELHA PORTUGUESA SAO CRISTOVAO > TELHA ROMANA LEONEL PEREIRA > TELHA TRANSPARENTE FRANCESA > TELHA TRANSPARENTE PORTUGUESA > TELHA TRANSPARENTE ROMANA > TELHA ZINCO 1 1/2 P/POSTE TELHADO > TELHAO FRANCES SAO CRISTOVAO * > TELHAO ROMANO SAO CRISTOVAO-GOIVA * > > > But in Linux the return is: > > prodes > ---------------------------------------------------- > TELHA FRANCESA CAMBORIU > TELHAO FRANCES SAO CRISTOVAO * > TELHAO ROMANO SAO CRISTOVAO-GOIVA * > TELHA PORTUGUESA SAO CRISTOVAO > TELHA ROMANA LEONEL PEREIRA > TELHA TRANSPARENTE FRANCESA > TELHA TRANSPARENTE PORTUGUESA > TELHA TRANSPARENTE ROMANA > TELHA ZINCO 1 1/2 P/POSTE TELHADO > > I already executed vacuumbd and reindex database but nothing. > > Somebody could help me? This probably is because you have a different collation set on the redhat box. If you are using something other than "C" locale, the ordering on the redhat box seems reasonable given that most locales ignore spaces for their first pass, so 'TELHAO' < 'TELHA P' for example. If you want byte ordering sorting, you can initdb in "C" locale. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 11/4/2005