Hello.


You can find an answer here:



  http://dev.mysql.com/doc/mysql/en/Charset.html



MySQL supports column character sets on columns of some types 

(char,varchar,text). Probably if I were you I would use Unicode 

in my application.



Graham Anderson <[EMAIL PROTECTED]> wrote:

> I have a mysql db that contains tables with multiple language fields

> for example...

> Artist_id   'PK'

> Artist_name

> Artist_pictLink

> Artist_purchaseLink

> Artist_bio_Spanish

> Artist_bio_English

> Artist_bio_German

> 

> I have other tables with a similar layout...Is this needlessly 

> complicated ?

> track_id   'PK'

> Artist_id   'FK'

> track_name_Spanish

> track_name_English

> track_name_German

> track_path

> track_versionTotal

> track_purchaseLink

> track_pictLink

> 

> Is there a better way to deal with tables  that need multiple language 

> fields...like creating another Db for that language ?

> 

> trying to get the design down before I end up with a huge headache...

> 

> many thanks

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to