Re: Problem with sql function LOWER

From: "Th Templ" <templ_th(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with sql function LOWER
Date: 2002-07-04 07:17:21
Message-ID: F160i5r5AO6FOvapM2H00007a8c@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

That's the problem! I try it the sql statement with a varchar field and it
works good.
Templth

>I'm guessing that Nom is of type char(N) and therefore has padding
>spaces in it. You should use varchar or text instead of char to
>avoid this sort of difficulty.
>
> regards, tom lane

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tomisław Kityński 2002-07-04 22:10:27 PreparedStatement and DB default values
Previous Message Bruce Momjian 2002-07-03 16:23:17 Re: switching db's on the fly