Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences:
The table below shows you a good comparison of CHAR and VARCHAR data types:
Value CHAR(4) Length '' ' ' 4 bytes 'ab' 'ab ' 4 bytes 'abcd' 'abcd' 4 bytes Value VARCHAR(4) Length '' '' 1 byte 'ab' 'ab' 3 bytes 'abcd' 'abcd' 5 bytes
2007-05-11, 4912👍, 0💬
Popular Posts:
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
How To Control Padding Spaces within a Table Cell? - XHTML 1.0 Tutorials - Understanding Tables and ...
Is Session_End event supported in all session modes ? Session_End event occurs only in “Inproc mode”...
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Con...
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wan...