dwax
asked on
.php insert text in mysql / strange characters
Hi,
I would like to add text into mysql, but there is something fishy going on.
When i try to put this word into mysql: geïsoleerd
it changes into: geïsoleerd
Note:
When submitted here, the values above change. The first word has an i with double dots.
The second has a capital A with an ~ on top and a High line.
Never had this problem before. Anyone knows what's going on?
I would like to add text into mysql, but there is something fishy going on.
When i try to put this word into mysql: geïsoleerd
it changes into: geïsoleerd
Note:
When submitted here, the values above change. The first word has an i with double dots.
The second has a capital A with an ~ on top and a High line.
Never had this problem before. Anyone knows what's going on?
try using htmlspecialchars() function to "encode" your text BEFORE you write it to the DB, or at least before you echo it to screen in a browser.
ASKER
Thanks for your reply.
I did try htmlspecialchars(), but it doesn't change it.
Never had this problem. This forum also suffers from this thing.
Any other ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hmm aparently the same issue appear here...