Serverside does not load unknown characters
Serverside does not load unknown characters
arsalansiddiqui
Posts: 128Questions: 15Answers: 0
Like the above image, it is not serverside=true but its show data with unknown characters like: � ï ½ ¿
But this one is datatable which is serverside=true but does not show unknown/special characters and just show processing message.
How to get rid of these issue ? I searched � on mysql but it does not show me anything, its not getting in filter
This discussion has been closed.
Answers
I suspect it's something to do with UTF8 characters in the database - these threads may help: here, here, and here.
Colin
My database/table collation is UTF8 general ci
Fixed.
I add:
$conn->set_charset("UTF8");
But my database/table collation is UTF8 general ci so why error ?
It's because you need to tell the PHP layer to expect UTF8 data. Glad all working.