Re: [JDBC] Char(100) fields

Can you please tell me how to know the encoding of the databse ?

rgds
Antony Paul

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Waldomiro" <wmiro(at)ig(dot)com(dot)br>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Thursday, September 23, 2004 1:20 AM
Subject: Re: [JDBC] Char(100) fields

> "Waldomiro" <wmiro(at)ig(dot)com(dot)br> writes:
> > now I have an error "value too long for type character(100)"
>
> Perhaps you are using unicode but forgot to set up the database with the
> proper encoding? The DB is going to count bytes not characters if it's
> in SQL_ASCII encoding, for example.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>