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:58:41 |
Message-ID: | 988991921.1662.2.camel@tonux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On 04 May 2001 11:40:48 -0400, Tom Lane wrote:
> > 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.
>
> But a non-MULTIBYTE backend doesn't even have the concept of "setting
> the encoding" --- it will always just report SQL_ASCII.
OK I just read the configure script for my backend - you guessed it
multibyte support and locale support compiled in there... So createdb -E
LATIN1 works just fine =:-b
> Perhaps what this really says is that it'd be better if the JDBC code
> assumed LATIN1 translations when the backend claims SQL_ASCII.
> Certainly, translating all high-bit-set characters to '?' is about as
> uselessly obstructionist a policy as I can think of...
I will be adding this snippet to my doc on techdocs in the French
version. It will save somebody a lot of head scratching.
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
From | Date | Subject | |
---|---|---|---|
Next Message | Kaare Rasmussen | 2001-05-04 15:59:18 | Re: Re: New Linux xfs/reiser file systems |
Previous Message | Tom Lane | 2001-05-04 15:40:48 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Grant | 2001-05-04 16:29:57 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Previous Message | Tom Lane | 2001-05-04 15:40:48 | Re: Re: A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |