Regarding insertion of Unicode String in Postgres using jdbc. - Mailing list pgsql-hackers

From Mamta Singh
Subject Regarding insertion of Unicode String in Postgres using jdbc.
Date
Msg-id 20040830094706.18624.qmail@web8505.mail.in.yahoo.com
Whole thread Raw
Responses Re: Regarding insertion of Unicode String in Postgres using  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Hi,

I have created a table

create table temp1(a varchar(200));

and then I tried running the following code.

String msg1 = "\u0000mamta";
PreparedStatement preparedStmt =
pgConnection.prepareStatement("insert into mamtanow
values(?)");

preparedStmt.clearParameters();
preparedStmt.setString(1, msg1);
preparedStmt.executeUpdate();        
preparedStmt.close();

And it throws an Exception saying "\0 not allowd"

what should I do ? How should I insert unicode string
using jdbc only ?

Thanks and Regards,
Mamta

=====
Mamta Singh

"Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity....."

________________________________________________________________________
Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony


pgsql-hackers by date:

Previous
From: Mamta Singh
Date:
Subject: Regarding the UnicodeString.
Next
From: Fabien COELHO
Date:
Subject: Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE