enigma1 - 11:49 am on Jul 30, 2010 (gmt 0)
It would seem that either the tool you have to browse the database or the database configuration isn't setup for UTF-8.
First, in the database, what you type in is what you should see. So check few things.
- If the database and all tables/columns for chars are setup for utf8_general_ci. And I am not sure about the ms sql but there should be an exact equivalent.
- When you connect to the database make sure you setup the charset to utf-8 also.
Second, when you edit directly into the db with your tool you should see all the characters exactly as you typed them. Without encodings. If you copy something from you db browsing tool into notepad you should see the exact characters as you originally typed them and the operations to the clipboard should not alter anything. If you see the hollow squares in notepad, then that means the db isn't setup right.
That's the whole idea behind utf-8 that supports the chars of all primary languages without having special encodings.