Sounds like DBF style behavior to me. :) -- rk -----Original Message----- From: dabo-users-boun...@leafe.com [mailto:dabo-users-boun...@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.4090...@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