MySQL ODBC Connector - Mapping from Boolean to Bit(1)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Mapping from Boolean to Bit(1)

Roland Volkmann

2005-09-17, 8:23 pm

Hello everybody,

I'm testing MySQL 5.0.12-beta with MyODBC-3.51.12-win32, both on WinXP.
If I export a Table from MS Access to MySQL, boolean fields are
transformed to Bit(1) in MySQL. That's fine so far.

But if I attach to that table from another Access Database, the Bit(1)
is mapped to "Text" in Access. It's the same with Access 97 or Access
2000. To have Boolean again or at least Numeric would be much better.

Is there a chance to change this behaviour?

With best regards,

Roland.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw

Sponsored Links