From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | Ryszard Lach <rla(at)id(dot)pl> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Problem with LATIN2 encoding |
Date: | 2002-07-12 20:19:16 |
Message-ID: | 3D2F39C3.8000307@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
What is the character set of your database? Issue the following query
to determine that: select getdatabaseencoding();
If getdatabaseencoding() returns the correct character set, then you
don't need to specify the charSet=LATIN2 on the URL as the driver
automatically uses the character set of the database it is connecting to.
If you are still having problems could you submit a test case that
demonstrates the problem?
thanks,
--Barry
Ryszard Lach wrote:
>Hi!
>
>I thing I've read almos all documents possible to find using google
>about character encoding and Java applications. Please, help me to
>understand why my strings are not inserted to database correctly.
>
>I'm using database in LATIN2 character set, postgresql7.2,
>postgresql-7.2.jar, postgresql compiled with multibyte enabled (the
>default configuration in Debian), application is a servlet running under
>Tomcat4.0.3, jdk1.3.1 from Sun.
>
>My database connection url contains 'charSet=LATIN2', but I'm not sure
>if it should be encoding of the database. If yes, then client (JVM
>running the servlet) working in UTF-8 should perform 'set
>client_encoding to UNICODE' before running any inserts to inform
>database engine about conversions, which it should perform, right ?
>
>I suppose not, because it doesn't work, the field in the database is
>being filled with question marks instead of every non-ASCII character.
>
>Can anybody help me ?
>
>regards,
>
>Richard.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aslak Hellesoy | 2002-07-13 20:00:44 | [BUG] Driver compile error |
Previous Message | Ryszard Lach | 2002-07-12 18:29:47 | Problem with LATIN2 encoding |