Re: [JDBC] Char(100) fields - Mailing list pgsql-general

From Antony Paul
Subject Re: [JDBC] Char(100) fields
Date
Msg-id BAY15-DAV15olmRBaYF000044bb@hotmail.com
Whole thread Raw
Responses Re: [JDBC] Char(100) fields  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Can you please tell me how to know the encoding of the databse ?

rgds
Antony Paul

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


> "Waldomiro" <wmiro@ig.com.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@postgresql.org)
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: download documentation as HTML (not PDF)
Next
From: Tom Lane
Date:
Subject: Re: [JDBC] Char(100) fields