Received: from as104.tel.hr (as104.tel.hr [205.219.255.36]) by hub.org (8.10.1/8.10.1) with ESMTP id e859wHC61937 for ; Tue, 5 Sep 2000 05:58:17 -0400 (EDT) Received: from adder (ao2-m136.tel.hr [195.29.33.136]) by as104.tel.hr (0.0.0/0.0.0) with SMTP id LAA393629 for ; Tue, 5 Sep 2000 11:58:16 +0200 (MEST) Message-Id: <4.1.20000905115800.014b15f8@pop.tel.hr> X-Sender: X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Tue, 05 Sep 2000 11:58:12 +0200 To: pgsql-interfaces@postgresql.org From: Zeljko Trogrlic Subject: JDBC and Unicode problem Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200009/7 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.