PostgreSQL 8.1 Zeoslib 6.6 and UTF8

[ganyovics]

Hi,

i have installed PostgreSQL 8.1, report manager 2.6 and Zeoslib 6.6. I have database with UTF8 encoding, but dates with UTF8 characters are not displayed correctly in report manager over zeoslib. Database with win1250 encoding is displayed correctly. What can be a problem? Does zeoslib supports UTF8 encoding?

Thanks.

[aperger]

Code: Select all

  // DB codepage
  ZConnection.Properties.Values['codepage']:='latin2';

  // Client side encoding
  ZConnection.Properties.Values['client_encoding']:='latin2';

So... you can set your onw... it works under Linux/Kylix 3.

[Strog]

I have similar problem ( also PostgreSQL )... I can't insert in table any values containing Serbian Latin letters ( ŠĐĆŽČćžšđč ) from my program but when I try to insert the values through pgAdmin with query:

Code: Select all

insert into katalog(ID, Naziv) values(18, 'ŠĐćžšđ')

everything works OK ( database and table have UTF8 encoding ).

When I try to run the same query from my program I get the error:

'ERROR: invalid byte sequence for encoding "UTF8": 0x8a'

I tried the code aperger gave us but nothing changes...

Any idea what should I do?

P.S. I have no problems with inserting other letters, just with those i wrote...

Thanks in advance!

Best regards,

Bojan Kopanja

[aperger]

Maybe your client side encoding is not the same as the server codepage... it can be different...

[Strog]

The thing is that it's not working even in local . I can't do that insert from the computer that has the server on it self.

[zeljko]

I have similar problem ( also PostgreSQL )... I can't insert in table any values containing Serbian Latin letters ( ŠĐĆŽČćžšđč ) from my program but when I try to insert the values through pgAdmin with query:

Code: Select all

insert into katalog(ID, Naziv) values(18, 'ŠĐćžšđ')

everything works OK ( database and table have UTF8 encoding ).

When I try to run the same query from my program I get the error:

'ERROR: invalid byte sequence for encoding "UTF8": 0x8a'

I tried the code aperger gave us but nothing changes...

Any idea what should I do?

P.S. I have no problems with inserting other letters, just with those i wrote...

Thanks in advance!

Best regards,

Bojan Kopanja

0x8A = 'Š' , in win1250 encoding, not in UTF-8.
Seem like your app sends win1250 chars into db , not UTF-8.

[gto]

My gods... sorry for the posting, I replyied in the wrong thread !