encoding problem on Tk entry widget

[filippo]

I have a strange problem, probably due to encoding:

my database tables (postgresql) have Latin9 encoding and stores
italian names (a e i o u with accent). I can retrieve these names and
load into entry widgets but if I copy-back these into database (from
entry widgets just loaded), these letters change to strange not-ascii
char.

I would not be a database problem because if I print to video the sql
insert strings, these contains the altready corrupted words.

How can I solve this problem?

Thanks,
Filippo

 

[Ch Lamprecht]

I have a strange problem, probably due to encoding:

my database tables (postgresql) have Latin9 encoding and stores
italian names (a e i o u with accent). I can retrieve these names and
load into entry widgets but if I copy-back these into database (from
entry widgets just loaded), these letters change to strange not-ascii
char.

I would not be a database problem because if I print to video the sql
insert strings, these contains the altready corrupted words.

How can I solve this problem?

Thanks,
Filippo

Hi,

maybe a

$dh->do("SET client_encoding TO 'UTF8'");

could help.

Christoph

 

[filippo]

filippo wrote:

$dh->do("SET client_encoding TO 'UTF8'");

thanks today I will try it.

I understand that could be a encoding problem between db (latin9) and
windows (utf8).

I know it's of topic here, but do you know how can I convert my
database from LATIN9 to UTF8 to avoid such problems?

Thanks,

Filippo

 

[Ch Lamprecht]

thanks today I will try it.

I understand that could be a encoding problem between db (latin9) and
windows (utf8).

I know it's of topic here, but do you know how can I convert my
database from LATIN9 to UTF8 to avoid such problems?

Thanks,

Filippo

Hi,

you won't have problems if you set your client_encoding to something your client
can handle. However, if you want to convert your database encoding, you will
have to dump the database (using pg_dump), recreate it with encoding set to UTF8
(CREATE DATABASE your_database_name WITH ENCODING = 'UTF8') and restore from
your backup file (using psql).

HTH, Christoph