to deal with multiple languages
Hello.
You can find an answer here:
http://dev.mysql.com/doc/mysql/en/Charset.html
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 [EMAIL PROTECTED] wrote
Hello.
You can find an answer here:
http://dev.mysql.com/doc/mysql/en/Charset.html
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 [EMAIL PROTECTED] wrote:
I have a
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 27, 2004 5:36 AM
Subject: Re: Newbie: How to deal with multiple languages
Hello.
You can find an answer here:
http://dev.mysql.com/doc/mysql/en/Charset.html
MySQL
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
Personally I would keep a table for the translations.
Some identifier for what it is, and then and id for the language.
So if something doesn't exist in one language you know about it and can
default to another language.
It also makes it easier to add new languages in my opinion.
somthing like:
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'