From: | "Antony Paul" <antonypaul24(at)hotmail(dot)com> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [JDBC] Char(100) fields |
Date: | 2004-09-23 03:57:28 |
Message-ID: | BAY15-DAV15olmRBaYF000044bb@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
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)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-09-23 04:02:15 | Re: [JDBC] Char(100) fields |
Previous Message | Tom Lane | 2004-09-23 00:20:36 | Re: download documentation as HTML (not PDF) |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-09-23 04:02:15 | Re: [JDBC] Char(100) fields |
Previous Message | Jaroslaw J. Pyszny | 2004-09-23 03:08:19 | Re: Auto-increment serial (Postgresql JDBC driver w/ |