Sounds like DBF style behavior to me. :)

--

rk

-----Original Message-----

From: dabo-users-bounces@leafe.com [mailto:dabo-users-bounces@leafe.com] On Behalf Of Paul McNett

Sent: Thursday, November 17, 2011 6:27 PM

To: Dabo Users list

Subject: [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

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/4EC59838.4090806@ulmcnett.com

_______________________________________________

Post Messages to: Dabo-users@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Searchable Archives: http://leafe.com/archives/search/dabo-users

This message: http://leafe.com/archives/byMID/DF1EEF11E586A64FB54A97F22A8BD0441D44FAF0CC@ACKBWDDQH1.artfact.local