From: | Quentin DELANCE <quentin(dot)delance(at)insalien(dot)org> |
---|---|
To: | Barry Lind <barry(at)xythos(dot)com> |
Cc: | Kovács Péter <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu>, Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: RE : ? (question mark) characters |
Date: | 2001-09-03 20:05:36 |
Message-ID: | 3B93E290.1A7484D4@insalien.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Barry Lind a écrit :
>
> Kovács Péter wrote:
> >>the driver what character set the backend is sending us? Can't
> >>it ask the backend dynamically?
> >>
> >>
> >
> > This is what it actually does, isn't it? (Based on what I usually see in the
> > trace output on the backend.) I tested a unicode database with varchar(255)
> > fields and hungarian accented characters and it worked just fine. (With
> > PostgreSQL 7.2.1 I think.)
> >
>
> Yes this is exactly what the driver does. It asks the server what
> character set is being used for the database. Unfortunatly the server
> only knows about character sets if multibyte support is compiled in. If
> the server is compiled without multibyte, then it always reports to the
> client that the character set is SQL_ASCII (where SQL_ASCII is 7bit
> ascii). Thus if you don't have multibyte enabled on the server you
> can't support 8bit characters through the jdbc driver, unless you
> specifically tell the connection what character set to use (i.e.
> override the default obtained from the server).
>
> thanks,
> --Barry
Thanks for the answer.
I am using a postgresql server rebuilt from a rawhide SRPM and I guess it is not
enabled by default (I can't check cause I don't have the SRPM anymore on my
hd...). It is a lot better to turn this option on by default though the current
solution (setting the charset properties manually fit me very well for my own
development).
Quentin
--
Quentin DELANCE
e-mail : quentin(dot)delance(at)insalien(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Robert J. Sanford, Jr. | 2001-09-03 20:06:07 | Re: JAVA vs PERL : PERL wins to postgreSQL |
Previous Message | Anders Bengtsson | 2001-09-03 19:34:37 | Re: JAVA vs PERL : PERL wins to postgreSQL |