You can find an answer here:
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'
> I have other tables with a similar layout...Is this needlessly
> complicated ?
> track_id 'PK'
> Artist_id 'FK'
> 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