Re: Regarding insertion of Unicode String in Postgres using

Try using a bytea field instead of a text one.

Chris

Mamta Singh wrote:

> 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