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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
