[eluser]Callista[/eluser]
In my content management system i have an WYSIWYG editor.
So the company can easily edit the text on the website pages.
But when i use special characters as: ' " ë é á etc.
it fails to upload into the database.
you get errors like:
Quote:A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near... etc.
I get why the error is occurring (because it fails on the special character)
but i haven't found a solution to fix it
(except stop using special characters but my company isn't so happy about that)
Do more people have this problem and how did you fixe it??
currently i'm using the WYSIWYG editor of: openwebware.com/