[solved] PostgreSQL - Char field filled space at end
Posted: 18.10.2013, 00:06
@EgonHugeist
trying to convert my aplication from 7.0.6 to 7.1.2 in thread ( http://zeoslib.sourceforge.net/viewtopi ... 942#p19285 ) i decide to do a test with 7.2 and i got the issue with postgresql 8.4 with Delphi 2009 with CHAR field.
Sample definition
in Zeos 7.0.6 and 7.1.2
in Zeos 7.2
there is space char filled at the end
trying to convert my aplication from 7.0.6 to 7.1.2 in thread ( http://zeoslib.sourceforge.net/viewtopi ... 942#p19285 ) i decide to do a test with 7.2 and i got the issue with postgresql 8.4 with Delphi 2009 with CHAR field.
Sample definition
Code: Select all
table s010usu.corpan = CHAR(20)
select corpan from s010usu
Code: Select all
Value returned = 'clWhite'
Code: Select all
Value returned = 'clWhite '