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 road....so 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 > portuguese_biography > > Is it better to make 1 db for each language or is there a more > efficient way to design a multi language db > > many thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]