[dabo-users] PostgreSQL char fields are rpadded

I'm using PostgreSQL for the first time, after long-time use of MySQL and SQLite. So

far so good, although I noticed a pretty key difference in character fields. For a

column definition of 'last_name char(30)', the following code:

biz.Record.last_name

Will result in the following on PostgreSQL:

"McNett "

Which surprised me greatly, because it results in the following output on MySQL and

SQLite:

"McNett"

I must be overlooking something exceedingly obvious, or I'd have seen this issue

discussed before. Right?

Paul

_______________________________________________

Post Messages to: Dabo-users@leafe.com