What is the best practice in storing pinyin characters in a MySQL database?

Question

I am storing Chinese pinyin characters into a MySQL column latin1_ci encoded. I noticed that I am losing information. I was wondering how or what is the correct way of storing pinyin characters. i.e

nǚ rén

The link above answers my question. – MontrealDevOne Oct 17 '13 at 23:31 — MontrealDevOne, Oct 17 '13 at 23:31

score 2 · Accepted Answer · answered Oct 17 '13 at 23:23

2

I recommend utf8 for the charset, utf8_general_ci for the collation.

answered Oct 17 '13 at 23:23

Tim Burch

1,082
7
9

Just did that. Thanx. I had get my charset to latin1, did not work. – MontrealDevOne Oct 17 '13 at 23:31

What is the best practice in storing pinyin characters in a MySQL database?

1 Answers1