I have never used those SET or ENUM type columns. It may be that Access does not support
them since they are a little unusual and are a MySQL extension to the SQL standard.
I did a little searching in Google for "mysql odbc access enum type" and came to the
conclusion that Access probably does not support these types of columns through ODBC.
Carl Zeiss Vision Australia (Asia Pacific)
Global Business Solutions/Customer Enablement
J o h n B o n n e t t
Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
This email, including any attachments, is intended for the sole use of the intended
recipient(s) and may contain information that is confidential, privileged and/or the
Any review or distribution by any other person is prohibited. If you are not an intended
recipient, please immediately contact the sender and delete all copies.
From: 重 博光 [mailto:hirobon@stripped]
Sent: Monday, 24 February 2014 3:24 PM
To: myodbc@stripped; Bonnett, John
Subject: Re: How to treat the SET type field?
As you mentioned, I didn't provide you enough information.
I will tell you what i tried to do and what i expected to happen.
I made a table as bellow.
CREATE TABLE IF NOT EXISTS `test` (
`no` int(11) NOT NULL AUTO_INCREMENT COMMENT 'No', `type` set('one','two','three','four')
NOT NULL COMMENT 'type', PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='test table'
INSERT INTO `test` (`no`, `type`) VALUES (1, 'three'), (2, 'two'), (3, 'three'), (5,
And I made a screen with MS Access2013(See attached file).
I expected that i can put the type field as a checkbox.
But It didn't work. It worked like a toggle button.
Did I make a mistake??
Thank you for any help.
This message is intended for a particular addressee only and may contain business or
If you have received this email in error, please contact the sender and delete the message
immediately. Any use of this email, including saving, publishing, copying, replication or
forwarding of the message or the contents is not permitted.