Free Web Hosting Forum
Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read
(#1 (permalink))
Old
Member
willettmatter is on a distinguished road
  
Posts: 61
Join Date: Jan 2012
Location: Idaho
Default mysql question - 02-03-2012, 05:00 PM
what is the difference between a varchar of X length, and a char of X length?
Reply With Quote
Sponsored Links
(#2 (permalink))
Old
Member
willettmatter is on a distinguished road
  
Posts: 61
Join Date: Jan 2012
Location: Idaho
Default 02-03-2012, 05:04 PM
more to the point of the question, does one require more space then the other?
Reply With Quote
(#3 (permalink))
Old
Senior Member
Firebirds is on a distinguished road
  
Posts: 252
Join Date: Feb 2012
Default 02-03-2012, 05:54 PM
Char is fixed length. Varchar isn't.
Varchar can hold up to 2k letters.
Char is much faster than Varchar.
Reply With Quote
Reply

Tags
field type, mysql

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump



Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.5.2
vBulletin Skin developed by: vBStyles.com

Free Web Hosting - Top