Foreign language in MySQL 4
Posted: Sat Jun 14, 2003 7:40 am
I have several tables in my database which are intended to be bilingual. In htis case, Japanese/English.
I have several instances where similar fields are duplicated and differentitated by a simple e_ or j_ at the beginning to indicate which language goes in that column. The Japanese columns are twice as long to allow for unicode issues in Asian languages. But, they are all Text(XX).
Three months later, and I'm finally ready to populate the database and my Japanese partner tells me there is a major problem.
The database fields will only hold 4 Japanese characters no matter how long we define them.
Can anyone provide any insight on what is going on here. I cannot seem to find the answer in the docs.
Thanks in Advance
-------------------------
SteedVLX
I have several instances where similar fields are duplicated and differentitated by a simple e_ or j_ at the beginning to indicate which language goes in that column. The Japanese columns are twice as long to allow for unicode issues in Asian languages. But, they are all Text(XX).
Three months later, and I'm finally ready to populate the database and my Japanese partner tells me there is a major problem.
The database fields will only hold 4 Japanese characters no matter how long we define them.
Can anyone provide any insight on what is going on here. I cannot seem to find the answer in the docs.
Thanks in Advance
-------------------------
SteedVLX