[jmartinph]

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)

[bcyde]

If you want variable length fields you should use varchar or the text type. That should stop the padding.

HTH,
-b

[jmartinph]

thank you... sir