Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Char(100) fields

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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)
> 

In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2004-09-23 04:02:15
Subject: Re: [JDBC] Char(100) fields
Previous:From: Jaroslaw J. PysznyDate: 2004-09-23 03:08:19
Subject: Re: Auto-increment serial (Postgresql JDBC driver w/

pgsql-general by date

Next:From: Tom LaneDate: 2004-09-23 04:02:15
Subject: Re: [JDBC] Char(100) fields
Previous:From: Tom LaneDate: 2004-09-23 00:20:36
Subject: Re: download documentation as HTML (not PDF)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group