* Eldon Ziegler
> I've been unable to select or set an enum field by using the
> string values.
> Numeric values work correctly.
> SHOW CREATE TABLE gives the following:
>
> CREATE TABLE `Organizations` (
> `OrgID` int(11) NOT NULL auto_increment,
> `Organization` varchar(50) NOT NULL default '',
> `TypeOrg` enum('Customer',' Vendor',' ThisOrg',' Other') NOT
'ThisOrg' is not the same as ' ThisOrg', note the leading space. You must
use ' ThisOrg' in your query, or change your enum to contain values without
a leading space.
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
