X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C6AB69FA6B4 for ; Tue, 20 Jun 2006 19:01:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 22957-04 for ; Tue, 20 Jun 2006 19:01:29 -0300 (ADT) X-Greylist: delayed 00:06:34.525042 by SQLgrey- Received: from sapo.pt (relay6.ptmail.sapo.pt [212.55.154.26]) by postgresql.org (Postfix) with SMTP id D51929FA6B3 for ; Tue, 20 Jun 2006 19:01:28 -0300 (ADT) Received: (qmail 4091 invoked from network); 20 Jun 2006 21:54:47 -0000 Received: from unknown (HELO sapo.pt) (10.134.35.207) by relay6 with SMTP; 20 Jun 2006 21:54:47 -0000 Received: (qmail 22888 invoked from network); 20 Jun 2006 21:54:46 -0000 X-AntiVirus: PTMail-AV 0.3-0.88.2 X-Virus-Status: Clean (0.00589 seconds) Received: from unknown (HELO hmv02) (hmv@[82.155.144.168]) (envelope-sender ) by mta12 (qmail-ldap-1.03) with SMTP for ; 20 Jun 2006 21:54:46 -0000 Message-ID: <006401c694b4$223d1390$6200a8c0@hmv02> From: =?iso-8859-1?Q?H=E9lder_M._Vieira?= To: References: <3770ee4b0606201209q75f8f6das1ee3ce246250e5cf@mail.gmail.com> Subject: =?iso-8859-1?Q?Re:_=5BSQL=5D_Problema_com_fun=E7=E3o_UPPER?= Date: Tue, 20 Jun 2006 22:54:35 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/234 X-Sequence-Number: 25470 Eduardo, creio que o problema decorre do jogo de caracteres usado... No meu caso, uma vez que vivo em Portugal, uso o jogo LATIN9 quando crio uma nova base de dados. Simplificando: CREATE DATABASE xpto WITH OWNER = postgres ENCODING = 'LATIN9' TABLESPACE = pg_default; Hélder M. Vieira ----- Original Message ----- From: Eduardo Giovany Schweigert To: pgsql-sql@postgresql.org Sent: Tuesday, June 20, 2006 8:09 PM Subject: [SQL] Problema com função UPPER Pessoal estou com um problema para usar a função Upper, pelo que parece esta havendo uma incompatibilidade pois qd rodo o sql no linux ((Gentoo) funciona legal, agora no windows não ta trazendo os resultados. Em ambos os casos estou usando o Postgresql 8.1 com PgAdmin 1.4.1, o sql é o seguinte. select * from pessoa where UPPER( dsnome ) like'ADÃO%' limit 10 no linux, retorna as 10 linhas, no windows não select * from pessoa where dsnome like'Adão%' limit 10 retorna as 10 linhas tanto num qt noutro. Agradeço qualquer ajuda.... -- Eduardo Giovany Schweigert (51) 9183-7474