Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
Thread Tools Display Modes
Share |
  #1  
Old 02-03-2009, 03:11 PM
2939195631902 2939195631902 is offline
Contributing Member
 
Join Date: 12-14-08
Posts: 140
iTrader: 0 / 0%
Lightbulb MYSQL: utf8_general_ci vs latin1_swedish_ci, MYISAM vs InnoDB

MYSQL Question/poll: utf8_general_ci vs latin1_swedish_ci and MYISAM vs InnoDB

Whats the difference between these two comparison and which one do you think is better for general use. I personally use both utf8 and latin1 for tables within a DB. Is there anything wrong with that?
 
Reply With Quote

Advertisement

Advertisement

  #2  
Old 02-04-2009, 01:46 AM
nasty.web nasty.web is offline
v7n Mentor
 
Join Date: 07-24-06
Posts: 688
iTrader: 1 / 100%
utf8 should be used to store international characters. It takes some more space on disk.
MyISAM is faster, InnoDB has transactions.
 
Reply With Quote
  #3  
Old 02-04-2009, 07:39 AM
2939195631902 2939195631902 is offline
Contributing Member
 
Join Date: 12-14-08
Posts: 140
iTrader: 0 / 0%
So if i plan add other language such as chinese, i should go with utf8?.
Do you know how much more space utf8 will take? is there like a ratio or something?
 
Reply With Quote
  #4  
Old 02-04-2009, 07:47 AM
nasty.web nasty.web is offline
v7n Mentor
 
Join Date: 07-24-06
Posts: 688
iTrader: 1 / 100%
Quote:
Originally Posted by 2939195631902 View Post
So if i plan add other language such as chinese, i should go with utf8?.
Do you know how much more space utf8 will take? is there like a ratio or something?
You should go with UTF8. And by the way ci in collation name means case insensitive. Be careful with that.

In UTF8 one character can be stored in multiple bytes. But standard characters like "a", "b", "9" require only one byte. For Hebrew, Cyrillic letters 2 bytes are used. For Japanese/Chinese up to 3.
 
Reply With Quote
  #5  
Old 02-04-2009, 10:37 AM
2939195631902 2939195631902 is offline
Contributing Member
 
Join Date: 12-14-08
Posts: 140
iTrader: 0 / 0%
Just to be clear, standard chars like a, b, c, and 9 only takes up 1 byte even if it's UTF8 while awkward chars takes up more.

Seems like UTF8 has all the advantages. Is there any downside at all comparing to the other one?

It's just my sql default is latin1_swedish_ci, and i want to figure what what makes it so good.
 
Reply With Quote
Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL? rob7676 Coding Forum 5 07-11-2008 04:53 PM
PHP and MySql help daniel0012 Coding Forum 4 06-28-2007 02:48 AM
Fun with mysql nasty.web Tech Talk 5 10-20-2006 10:38 AM
MYSQL gatorgritz Web Design Lobby 7 07-05-2006 10:24 PM
MySQL help cbolts Web Design Lobby 2 04-09-2004 06:39 AM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 09:37 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC