[mdb-dev] Re: Very very weird connection error - unixODBC

[Rob P. <ro...@el...>]

> I am not sure, but I think this junk is a UCS-2 string...  The other
> problem is that mdbtools SQL parser still can not handle Unicode
> strings.

Okay, you're talking a LITTLE over my head there!  :-)  Is your suggestion
that my Linux locale settings may somehow be causing the conflict?  The
various mdbtools work okay (apart from one problem - see below), just not
the unixODBC connection.

> There is a patch in [1] for mdbtools which could temporally
> fix this error.
> [1] http://sourceforge.net/tracker/?group_id=3D2294&atid=3D302294

Unfortunately this link seems to send me to a page saying "Error -
ArtifactType: Invalid ArtifactTypeID".  I tried looking amongst the various
patches on the mdbtools site, but none of them seemed to relate to this
problem, and moreover, I couldn't see how to apply the patches.  (Yup, you
guessed right, not a C programmer!)

My other problem with mdbtool is one that I've mentioned on this list
before.  I was having it with version 0.5 and I still get it with the CVS
version.  Specifically, numbers are being truncated.  mdbexport will chop
off any part of the number over 99,999 (eg number going in is £310,000;
number coming out is £10,000).  mdbschema suggests that the columns in
question are of type Currency (8).

Any ideas/solutions?  If this problem could be resolved, mdbtools would
become significantly more useful to me...

Thanks in advance; apart from these issues, the software is a great help!

Rob
--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333