Postgeressql varchar field size problem.
Posted: 18.02.2013, 12:54
Postgresql allows to use character varying field type without field size limit, this allows storying a string with any length (max about 1GB chars).
Create Table test
(
testfield varchar
)
Now I use a query:
Select * from test
In this case Zeos creates a string field for 'testfield' and limits its size to 255 chars (or 512), which truncates the output. I can modify a source to increase the default, but it should be handled in some more elegant way - maybe as a parameter to the connection or query or so.
Create Table test
(
testfield varchar
)
Now I use a query:
Select * from test
In this case Zeos creates a string field for 'testfield' and limits its size to 255 chars (or 512), which truncates the output. I can modify a source to increase the default, but it should be handled in some more elegant way - maybe as a parameter to the connection or query or so.