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, 4952👍, 0💬
Popular Posts:
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
What is the sequence of UML diagrams in project? First let me say some fact about this question, you...
Can we get a strongly typed resource class rather than using resource manager? In the previous quest...
Can event’s have access modifiers ? Event’s are always public as they are meant to serve every one r...
What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...