TOPIC: ENUM field with apostrophe does not work

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

It's a bug

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




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