Jump to content


Photo

Storing Multiple Languages in a DB


  • Please log in to reply
3 replies to this topic

#1 n8w

n8w
  • Members
  • PipPipPip
  • Advanced Member
  • 123 posts

Posted 04 March 2006 - 06:58 PM

I am going to create a site that will have content written in English, French, Italian and German

Is there anything I need to consider for storing this information in a database? or other considerations I should be aware of?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 March 2006 - 07:15 PM

Consider using UTF-8 as the character set.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 n8w

n8w
  • Members
  • PipPipPip
  • Advanced Member
  • 123 posts

Posted 04 March 2006 - 07:24 PM

[!--quoteo(post=351659:date=Mar 4 2006, 04:15 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Mar 4 2006, 04:15 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Consider using UTF-8 as the character set.
[/quote]

is that something I do with the database .. or just as a meta tag in html?


#4 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 05 March 2006 - 01:42 AM

That's the character set you want to have as the default on every MySQL table you create. Once it's set as the default for a table, you won't have to worry about it when you pull or store values.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users