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
Foreign language in MySQL 4
Moderator: General Moderators
Thanks for the ideas..
It seems thatthe problem was with the Admin GUI that I was using to work with my database. I am using MySQLCC to build and maintain the DB. I really like it and hope they continue development. BTW.
Anyway, I decided to make some of my own admin pages to try things out. They worked fine the first time. So I went out and snarfed a copy of phpMyAdmin to work with my test data.
Sorry. I should have thought about the Admin proggy first off.
---------------
SteedVLX
It seems thatthe problem was with the Admin GUI that I was using to work with my database. I am using MySQLCC to build and maintain the DB. I really like it and hope they continue development. BTW.
Anyway, I decided to make some of my own admin pages to try things out. They worked fine the first time. So I went out and snarfed a copy of phpMyAdmin to work with my test data.
Sorry. I should have thought about the Admin proggy first off.
---------------
SteedVLX