varchar in postgreSql
Posted: 23.11.2009, 18:34
Hi ZeOsLib crew 
EDIT: mistake: with field type text, the results are correct. It does not explain why verchar and varchar(100000) does not work...
I use ZeOsLib 6.6.5 on delphi 7 and PG 8.4.
I have a table containing a field of varchar type. (no length)
this field can contain long strings : 30000 characters or more.
When I select data from this field, I only get the 255 first characters...
If i add a precision to the field (varchar(100000)), or change the field type to text, I only get the 4096 first characters.
I executed my project step by step to see that the function PQgetvalue from PG client dll (ZPlainPostgreSqlDriver.TZPostgreSQL8PlainDriver.GetValue), is the one which returns the truncated strings...
Is there a known solution to avoid this problem ?
Thanks in advance for any help.
pe why
EDIT: mistake: with field type text, the results are correct. It does not explain why verchar and varchar(100000) does not work...
I use ZeOsLib 6.6.5 on delphi 7 and PG 8.4.
I have a table containing a field of varchar type. (no length)
this field can contain long strings : 30000 characters or more.
When I select data from this field, I only get the 255 first characters...
If i add a precision to the field (varchar(100000)), or change the field type to text, I only get the 4096 first characters.
I executed my project step by step to see that the function PQgetvalue from PG client dll (ZPlainPostgreSqlDriver.TZPostgreSQL8PlainDriver.GetValue), is the one which returns the truncated strings...
Is there a known solution to avoid this problem ?
Thanks in advance for any help.
pe why