how to store phonetics in mysql database

Question

I have to store the phonetics of words in a database in this format:

blow = \ˈblō\

But when I see in the database, it's stored like this:

blow = \?bl?\

There are ? instead of symbols you can see.

Please correct me as to what I am doing wrong.

Thanks

Most likely an encoding issue. Make sure you go UTF-8 all the way. — Funk Forty Niner, Jun 25 '14 at 03:15
try to read this one pal... http://dev.hubspot.com/blog/bid/7049/MySQL-and-Unicode-Three-Gotchas — Datz Me, Jun 25 '14 at 03:39

score 3 · Accepted Answer · answered Jun 25 '14 at 03:18

3

your database does not support all characters i would recommend to change it to something like this:

character set: utf8
collation: utf8_general_ci

right now you have a standard character set and thats why it changes to ?????

answered Jun 25 '14 at 03:18

lauw

1 Answers1