Postgres 8, zeos 6.6.6, FPC 2.4.4, VARCHAR problem
Posted: 29.06.2011, 17:27
Hi,
From a few days i tried to resolve zeos problem with PostgreSQL VARCHAR type columns. In Zeos 7 it works ok (tested only on DELPHI) but in 6.6.6 not.
In connection with PostgreSQL 8 there is a problem with string fields length on columns VARCHAR. DB is UTF8 and everything is OK until you have VARCHAR column with Polish (for example) national characters. Zeos sets wrong length result strings. It looks like this setting is made due to field length not size.
For example if we have VARCHAR12 and 12 char text with 1 national sign - result string is croped with 1 sign. If we change column type to VARCHAR13 everything is ok, the same if we change column type to TEXT. Where is a place in zeos code to look this behaviour ?
I MUST have working zeos on FPC and last FPC compatible version is 6.6.6
Thanks for any help !
Regards
Jaromir
From a few days i tried to resolve zeos problem with PostgreSQL VARCHAR type columns. In Zeos 7 it works ok (tested only on DELPHI) but in 6.6.6 not.
In connection with PostgreSQL 8 there is a problem with string fields length on columns VARCHAR. DB is UTF8 and everything is OK until you have VARCHAR column with Polish (for example) national characters. Zeos sets wrong length result strings. It looks like this setting is made due to field length not size.
For example if we have VARCHAR12 and 12 char text with 1 national sign - result string is croped with 1 sign. If we change column type to VARCHAR13 everything is ok, the same if we change column type to TEXT. Where is a place in zeos code to look this behaviour ?
I MUST have working zeos on FPC and last FPC compatible version is 6.6.6
Thanks for any help !
Regards
Jaromir