CODEWITHSUNDEEP
mysqldatabasedatabase-designlocalization
Wolfpack'08
Wolfpack'08

Reputation: 4128

Do I need a new table for a new language?

Do I need to create a different table for each new language?

Here's a sample table:

field
id   
field
lang 
filter
count

Say someone inputs data in English, then they input data in Japanese, then they input data in Russian.... Is that going to be acceptable? Or rather, is there a good way to make it possible because I get the following error, making me believe that I should re-design:

Warning: #1366 Incorrect string value: '\xE8\x8B\xB1\xE8\xAA\x9E' for column 'field' at row 1

Upvotes: 0

Views: 86

Answers (1)

iehrlich
iehrlich

Reputation: 3580

You can use Unicode to allow all languages within your database. Clients should also process and transfer captured data in Unicode.

Upvotes: 1

Related Questions