Re: Problem with sql function LOWER - Mailing list pgsql-jdbc

From Th Templ
Subject Re: Problem with sql function LOWER
Date
Msg-id F160i5r5AO6FOvapM2H00007a8c@hotmail.com
Whole thread Raw
In response to Problem with sql function LOWER  ("Th Templ" <templ_th@hotmail.com>)
List 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 world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com




pgsql-jdbc by date:

Previous
From: Toby Doig
Date:
Subject: Re: Servlet uplad with Multipart and LO
Next
From: David Garnier
Date:
Subject: Retrieving binary data