Foreign language in MySQL 4

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
steedvlx
Forum Contributor
Posts: 122
Joined: Wed Jun 11, 2003 10:54 pm
Location: Osaka, Japan

Foreign language in MySQL 4

Post 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
Judas
Forum Commoner
Posts: 67
Joined: Tue Jun 10, 2003 3:34 pm
Location: Netherlands

Post 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.
User avatar
steedvlx
Forum Contributor
Posts: 122
Joined: Wed Jun 11, 2003 10:54 pm
Location: Osaka, Japan

Post 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
Judas
Forum Commoner
Posts: 67
Joined: Tue Jun 10, 2003 3:34 pm
Location: Netherlands

Post by Judas »

:) np
Post Reply