Page 1 of 1

Foreign language in MySQL 4

Posted: Sat Jun 14, 2003 7:40 am
by steedvlx
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

Posted: Sat Jun 14, 2003 12:36 pm
by Judas
Try binary data storage.
Or even gz the text data before storing it.
And check the max.chars in your sql field.
Try to avoid sending data by post vars.
Don't drink to much coffee.

Posted: Sat Jun 14, 2003 1:34 pm
by steedvlx
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. :oops:

---------------
SteedVLX

Posted: Mon Jun 16, 2003 9:55 am
by Judas
:) np