Обсуждение: Charset issue when storing data

Hello,

I have a strange behavior using last version of JDBC driver (version
does not matter). When I store data in the DB using JDBC (actually
hibernate), some special char are corrupted. But if I directly store
data in the DB using pgadmin, it is ok and well displayed in the webapp
(it means that the JDBC driver retrieves it correctly). Additionally if
I deploy my webapp on my  dev machine  and  configure it to connect to
the  production database, there is no more problem, data is well stored.

I can't figure what's wrong on my production server as it deals well
with unicode char ...

Do you have any idea ?

Thanks

- Aymeric

Aymeric,

What is the encoding on the server ?

Dave
On 21-Mar-06, at 7:48 AM, Aymeric Levaux wrote:

> Hello,
>
> I have a strange behavior using last version of JDBC driver
> (version does not matter). When I store data in the DB using JDBC
> (actually hibernate), some special char are corrupted. But if I
> directly store data in the DB using pgadmin, it is ok and well
> displayed in the webapp (it means that the JDBC driver retrieves it
> correctly). Additionally if I deploy my webapp on my  dev machine
> and  configure it to connect to the  production database, there is
> no more problem, data is well stored.
>
> I can't figure what's wrong on my production server as it deals
> well with unicode char ...
>
> Do you have any idea ?
>
> Thanks
>
> - Aymeric
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>