From: | Tony Grant <tony(at)animaproductions(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Barry Lind <barry(at)xythos(dot)com>, Jani Averbach <jaa(at)cc(dot)jyu(dot)fi>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Date: | 2001-05-04 15:36:07 |
Message-ID: | 988990567.1662.1.camel@tonux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On 04 May 2001 10:29:50 -0400, Tom Lane wrote:
> > With regards to your specific problem, my guess is that you haven't
> > created you database with the proper character set for the data you are
> > storing in it. I am guessing you simply used the default SQL Acsii
> > character set for your created database and therefore only the first 127
> > characters are defined. Any characters above 127 will be returned by
> > java as ?'s.
>
> Does this happen with a non-multibyte-compiled database? If so, I'd
> argue that's a serious bug in the JDBC code: it makes JDBC unusable
> for non-ASCII 8-bit character sets, unless one puts up with the overhead
> of MULTIBYTE support.
I fought with this for a few days. The solution is to dump the database
and create a new database with the correct encoding.
MULTIBYTE is not neccesary I just set the type to LATIN1 and it works
fine.
Queries even work on accentuated caracters!!!
I have a demo database for those interested
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Ultradev and PostgreSQL
http://www.animaproductions.com/ultra.html
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-04 15:40:48 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Previous Message | Karl DeBisschop | 2001-05-04 15:28:09 | Re: Packaging 7.1.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-04 15:40:48 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Previous Message | Tom Lane | 2001-05-04 14:29:50 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |