November 20th, 2003, 09:53 PM
on retrieve: extra space is too much
I ported my database from Sybase to PostgreSQL
Its weird that everytime I create a new record if the field length
is say char(20) and what i've entered as the field value is
say 'JUN MARTIN' length: 10 (single quote to represent string) then everytime I retrieve the same record or any other record the length of the field value is not actually 10 but 20, filling the remaining 10 characters with space.
How do I disallow this default behavious.. is this possible?
I'm using PowerBuilder .. i believe client dev. env is not the problem.. it may be the database server or the odbc driver ( i'm using the latest release for Windows)
November 21st, 2003, 09:04 AM
If you want variable length fields you should use varchar or the text type. That should stop the padding.
PostgreSQL, it's what's for dinner...
November 23rd, 2003, 09:53 PM