Regarding insertion of Unicode String in Postgres using jdbc.

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend