JDBC and Unicode problem

From: Zeljko Trogrlic <zeljko(at)post(dot)hinet(dot)hr>
To: pgsql-general(at)postgresql(dot)org
Subject: JDBC and Unicode problem
Date: 2000-09-04 12:08:23
Message-ID: 4.1.20000904140009.0184d320@pop.tel.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm trying to store / retrieve data from UNICODE database, but without success.

I installet PostgreSQL 7.02 binaries for RedHat Linux on RH 6.2
I created database with UNICODE as charset (createdb -E UNICODE name)
I can establish JDBC connection and everything works fine when I use ASCII
characters.
When I use non-ASCII characters, I get all kind of stuff.

I tried to store data using
* setString
* setObject
* setBytes
* setUnicodeStream

without success.

My questions are:
* Are binaries configured for UNICODE support?
* How can I check are binaries configured for UNICODE support?
* Do I have to set somethinh in Java in order to get UNICODE working?
* Which method should I use to read UNICODE data?

I have to enter multilingual data so I can't switch to national character set.
v
Zeljko Trogrlic
____________________________________________________________

Aeris d.o.o.
Sv. Petka 60 b, HR-31000 Osijek, Croatia
Tel: +385 (31) 53 00 15
Email: mailto:zeljko(at)post(dot)hinet(dot)hr

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Smith 2000-09-04 12:14:31 That killer 3rd join...
Previous Message Gabriel Fernandez 2000-09-04 10:32:02 Problem with drop table within a transaction