Re: creating a DB wwith multiple languages

2004-06-08 Thread Ligaya Turmelle
Why not set the table to - CHARACTER SET utf8; Respectfully, Ligaya Turmelle <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am just beginning down this roadso the answer may be obvious > > Is there an efficient way to design a database where the table data > contains fields w

Re: creating a DB wwith multiple languages

2004-06-08 Thread Ligaya Turmelle
Why not set the DB character set to utf8 and probably cover all of them? CHARACTER SET utf8; Respectfully, Ligaya Turmelle <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am just beginning down this roadso the answer may be obvious > > Is there an efficient way to design a da

creating a DB wwith multiple languages

2004-06-08 Thread grahama
I am just beginning down this roadso the answer may be obvious Is there an efficient way to design a database where the table data contains fields with multiple languages ? like the Artist Table: artist_id english_name spanish_name portuguese_name english_biography spanish_biography portugues