Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4697👍, 0💬
Popular Posts:
How To Compare Two Strings with strcmp()? - PHP Script Tips - PHP Built-in Functions for Strings PHP...
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Pat...
What does static variable mean? There are 3 main uses for static variables: If you declare within a ...
What is CAR (Causal Analysis and Resolution)? The basic purpose of CAR is to analyze all defects, pr...