List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:November 27 2004 10:36am
Subject:Re: Newbie: How to deal with multiple languages
View as plain text  
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 <grahama@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Newbie: How to deal with multiple languagesGraham Anderson26 Nov
  • Re: Newbie: How to deal with multiple languagesLigaya Turmelle28 Nov
    • Re: Newbie: How to deal with multiple languagesMichael J. Pawlowsky28 Nov
  • Re: Newbie: How to deal with multiple languagesGleb Paharenko28 Nov
  • Re: Newbie: How to deal with multiple languagesRhino28 Nov
    • Re: Newbie: How to deal with multiple languagesGraham Anderson30 Nov