SQL data character set configuration

Days ago I posted an article containingĀ Greek characters which didn’t go as expected, but I failed to look further in this issue. I totally didn’t realize that it has some thing to do with my database character set configuration.

But today, a friend post a comment on my page and it’s so sad that the comment became multiple question marks “????…”. And this is when I realized that there was something wrong and by Googling I gained the knowledge that it may has something to do with my American free web space provider, who provided SQL database but in latin character set as default, which leads to the whole following things.

It’s tough to change the character set field by filed but finally I made it, and this web site is supposed to be compatible with all UTF-8 characters.