How to change the character set of a mysql database after setting it to the wrong character set. In fact, i'm having some problems for printing special characters pulled from a mysql database. It is a php programming language.
Asked
Active
Viewed 28 times
1 Answers
0
There are several things you could be doing wrong. Please study the 'best practices' in here
If that does not suffice, perhaps the it can help with "problems printing".
If still not sufficient, show us the connection, set_charset, SHOW CREATE TABLE, sample printout, and sample of text that is giving trouble.
Community
- 1
- 1
Rick James
- 135,179
- 13
- 127
- 222
-
Although the link you provided contains some useful infos but it's not what i'm actually looking for. – kourouma_coder Mar 05 '17 at 22:31
-
It covers "Black Diamonds", which you have. However, there are two sub-cases, read the discussion and let us know which you have. – Rick James Mar 06 '17 at 00:30
-
Also, without `SELECT HEX(...) ...`, we can't be really sure what is in the table. – Rick James Mar 06 '17 at 00:33