Menu
Community /Pin to ProfileBookmark
@NogDogJul 14.2019 — #What character set are you using for that column in the DB? Maybe you just need to change it to a multi-byte unicode set like UTF8? @NogDogJul 15.2019 — #
It's a kludge of sorts, in that your data now becomes HTML-specific, versus just being data that represents the actual user input. If you don't feel inclined to fix the database, then it will probably "work". 🤷♂️
Delete or edit special characters from a string
Dear users,
I want to store in my mysql database some data sent from my website users.
If I try to enter a string like “na 😍”, containing some special characters, I receive this error:
ERROR 1366: 1366: Incorrect string value: ‘xF0x9Fx98x8D’ for column ‘text_se’ at row 1
Now, via PHP I want to edit the string sent by the users, so I can store in the database, or if it isn’t possible, I want to delete those characters from the string.
How to do it?
Thanks
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJul 14.2019 — #0
@NogDogJul 15.2019 — #>@redagr#1606315 If I use htmlentities before sending to sql command, will I fix the issue?
It's a kludge of sorts, in that your data now becomes HTML-specific, versus just being data that represents the actual user input. If you don't feel inclined to fix the database, then it will probably "work". 🤷♂️