Page 1 of 1
PostgreSQL 8.1 Zeoslib 6.6 and UTF8
Posted: 29.01.2007, 15:44
by 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.
Posted: 06.02.2007, 08:23
by 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.
Posted: 06.02.2007, 10:52
by 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
Posted: 06.02.2007, 11:10
by aperger
Maybe your client side encoding is not the same as the server codepage... it can be different...
Posted: 06.02.2007, 12:45
by 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.
Posted: 18.02.2007, 21:03
by zeljko
Strog wrote: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.
Posted: 31.08.2009, 18:46
by gto
My gods... sorry for the posting, I replyied in the wrong thread !