ENUM field with apostrophe does not work

More
6 years 10 months ago #4387 by linsoussi
ENUM field with apostrophe does not work was created by linsoussi
Hello,
When an apostrophe appear in a ENUM field, joodb can not create the corresponding value in the data. For instance ENUM('Ecole d\'Aménagement et de Gestion de l\'Environnement','Ecole d\'Economie de Socio Anthropologie et de Communication pour le Développement Rural','Ecole de Nutrition et des Sciences et Technologies Alimentaires','Ecole des Sciences et Techniques de Production Animale','Ecole des Sciences et Techniques de Production Végétale') won't work witn joodb.

In other words when a field of a record should have a value from an ENUM, if this value contains an apostrophe, then the field is merely set to null.

Please, how to escape to get the data updated?

Thanks

Please Log in to join the conversation.

More
6 years 10 months ago #4388 by Dirk
Replied by Dirk on topic ENUM field with apostrophe does not work
It's a bug

Please extract and replace the file form.php in /administrator/components/com_joodb/helpers
with the new one.

Attachment form.php.zip not found




Alernatively you can use a single Quotation mark like this instead ’

This message has an attachment file.
Please log in or register to see it.

Please Log in to join the conversation.

Moderators: Dirkjoest