Created attachment 71864 [details] comparative screenshot between isql and ActualTech ODBC driver On Mac OSX, it is possible to access mysql and postgresql data sources via the Actual Technologies ODBC driver. This is paying software, but a free trial is available for testing that returns the first three rows of the result set. On the daily master build : Version 4.1.0.0.alpha0+ (Build ID: 1e65f0176a9243274971321ffa5b6462130904e) TinderBox: MacOSX-Intel@1-built_no-moz_on_10.6.8, Branch:master, Time: 2012-12-20_00:42:24 the display of the table is corrupted by spurious padding characters added after the actual data. A screenshot comparison showing the data displayed using the ActualTechnologies driver and isql clearly shows this difference. Alex
adding Lionel, Thorsten, Norbert to CC
I have contacted Actual Technologies about this with the same information.
Tested also with : LO 334 : even worse display results, virtually all of the varchar/char fields are truncated to the first character of the data string LO 357 : no problem, displays correctly. LO 364 : no problem, displays correctly. So this is definitely a regression introduced somewhere during 3.7/4.0 development. Marking as such. Alex
Are the affected fields only VARCHAR, or also CHAR?
Hi Lionel, The client field is VARCHAR, the country field is CHAR, so the answer is both. This sounds similar to the bug that we saw in the bibliography db, but I thought that had been fixed ? Alex
(In reply to comment #5) > Hi Lionel, > > > The client field is VARCHAR, the country field is CHAR, so the answer is > both. This sounds similar to the bug that we saw in the bibliography db, but > I thought that had been fixed ? > > Alex The country field is a CHAR(2) field type. Alex
*** This bug has been marked as a duplicate of bug 58693 ***