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
