Received: from gabuzo.meunet (IDENT:root@d224.paris-204.cybercable.fr [212.198.204.224]) by hub.org (8.9.3/8.9.1) with ESMTP id CAA32060 for ; Tue, 27 Apr 1999 02:07:45 -0400 (EDT) (envelope-from christophe.labouisse@dial.oleane.com) Received: (from moi@localhost) by gabuzo.meunet (8.9.1a/8.9.1/Christophe Labouisse - 10/01/99) id IAA11086; Tue, 27 Apr 1999 08:03:03 +0200 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Strange behavior References: <4450.925161834@sss.pgh.pa.us> Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: multipart/mixed; boundary="Multipart_Tue_Apr_27_08:03:03_1999-1" Content-Transfer-Encoding: 7bit From: Christophe Labouisse Date: 27 Apr 1999 08:03:03 +0200 In-Reply-To: Tom Lane's message of "Mon, 26 Apr 1999 17:23:54 -0400" Message-ID: Lines: 34 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" --Multipart_Tue_Apr_27_08:03:03_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Tom Lane writes: > > select crit_url from crit where crit_url like 'films/%' order by crit_url; > > [ gives wrong results, whereas this gives right results: ] > > select crit_url from crit where crit_url like '%films/%' order by crit_url; > > What locale and/or MULTIBYTE setting are you using? fr_FR > > There is a hack in the parser that tries to transform the first of these > into this: > > select crit_url from crit where crit_url like 'films/%' > AND crit_url >= 'films/' AND crit_url <= 'films/\377' > order by crit_url; Well I guess that's it since \377 in fr_FR is ˙ (ydierisis). --Multipart_Tue_Apr_27_08:03:03_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Christophe Labouisse : Cinéma, typographie, Unix christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/ Le cinéma en Lumičre : http://www.lumiere.org/ --Multipart_Tue_Apr_27_08:03:03_1999-1--