Re: Newbie: How to deal with multiple languages

[Ligaya Turmelle]

Looks good to me but I'm a relative beginner.  Maybe another option - 
make Spanish, English, and German tables, then link those to the main 
table.  This however can slow you down if you are doing multiple reads 
of the various tables.

Respectfully,
Ligaya Turmelle
Graham Anderson 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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]