Hi,
When I try to give a default value in an enum field with a string
containing extented ascii value (i.e. higher than 128), I get an 'Invalid
default value for enum_field' error. For instance, the command:
alter table MyTable add AnEnumField enum('Employé', 'Producteur',
'Actionnaire')
not null default 'Employé'
produces an error, but if I strip the accents on 'Employe', the command
works well. Anyone know if I can bypass this bug in any way?
Thanks
Denis Simard
DBAdmin
HEXACTO
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
