What is the difference between CHAR and VARCHAR data types?
This is a discussion on What is the difference between CHAR and VARCHAR data types? within the Database Support forums, part of the Web Development category; Hi, Any one Explain. --Sundar...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
02-01-2008, 10:34 PM
| |||
| |||
 What is the difference between CHAR and VARCHAR data types? Hi, Any one Explain. --Sundar     |
| Sponsored Links |
|
02-01-2008, 10:36 PM
| |||
| |||
 Re: What is the difference between CHAR and VARCHAR data types? CHAR CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" will be stored as "Hello! " in CHAR(10) column. VARCHAR VARCHAR is a variable length data type. VARCHAR(n) will take only the required storage for the actual number of characters entered to that column. For example, "Hello!" will be stored as "Hello!" in VARCHAR(10) column. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| SQL Server Data Types and Ranges. | Sundaram | Database Support | 7 | 11-14-2008 05:11 AM |
| What is the difference between global and action sheets within the data table in QTP? | sundarraja | Testing Tools | 1 | 08-13-2007 11:50 PM |
| How can I implement opaque (abstract) data types in C? | prasath | C and C++ Programming | 1 | 07-30-2007 04:24 AM |
| Convert integer type variable to char array | oyu2o | C and C++ Programming | 0 | 03-10-2007 09:47 AM |
| Java:Tutorial - Data Types | pranky | Java Programming | 0 | 02-24-2007 12:47 AM |
All times are GMT -7. The time now is 06:07 AM.
