Oracle SQL - What Are the Differences between CHAR and VARCHAR2

Interview Question Database For Software Developers

Categories:
    .NET (563)
    C (56)
    C++ (1)
    CSS (83)
    DBA (2)
    General (25)
    HTML (43)
    Java (64)
    JavaScript (97)
    JSP (44)
    JUnit (31)
    MySQL (292)
    Networking (10)
    Oracle (438)
    Perl (8)
    Perl (2)
    PHP (259)
    PL/SQL (137)
    RSS (51)
    Software QA (18)
    Struts (20)
    XHTML (197)
    XML (58)

Atom Atom feed

Index List view

Developer Resources

Java JAR Files

DLL Files

DBA Resources

Software QA Resources

Programming Tutorials

Biotech Resources

Link Directories

Windows Tutorials

Interview Q & A

FYIcenter Forum
[ Home | What's new | What's popular | Add a question ]
Top > Oracle > SQL
What Are the Differences between CHAR and VARCHAR2
What Are the Differences between CHAR and VARCHAR2? - Oracle DBA FAQ - Understanding SQL Basics
By: FYIcenter.com

The main differences between CHAR and VARCHAR2 are:

  • CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length.
  • VARCHAR2 stores values in variable lengths. Values are not padded with any characters.
ID: 804 | Rank: 1075 | Votes: 0 | Views: 29 | Submitted: 20070424
Rate this item:
Vote total counts:1
Vote total score:0  :-)
Your vote:
:-(-3-2-1+1+2+3:-)
 

Submit your comment:
Comment:
(< 2048 char.)
Your Name:
  (All fields are required.)
Related Items:
What Are the Oracle Built-in Data Types
What Are the Oracle Built-in Data Types? - Oracle DBA FAQ - Understanding SQL Basics...                                                                                      
Submitted: 20070424
What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - Oracle DBA FAQ - Understanding SQL Basics...                                                                              
Submitted: 20070424
What Are the Differences between CHAR and VARCHAR2
What Are the Differences between CHAR and VARCHAR2? - Oracle DBA FAQ - Understanding SQL Basics...                                                                          
Submitted: 20070424
What Are the Differences between NUMBER and BINARY_FLOAT
What Are the Differences between NUMBER and BINARY_FLOAT? - Oracle DBA FAQ - Understanding SQL Basics...                                                                    
Submitted: 20070424
What Are the Differences between DATE and TIMESTAMP
What Are the Differences between DATE and TIMESTAMP? - Oracle DBA FAQ - Understanding SQL Basics...                                                                          
Submitted: 20070424
[ Home | What's new | What's popular | Add a question ]

How To Commit the Cu...

How To Commit the Current Transaction? - MySQL FAQs - Transaction Management: Commit or Rollback...                                                                

interview.fyicenter.com/1171...

How can we check tha...

How can we cancel all changes done in dataset ? or How do we get values which are changed in a dataset ?...                                                      

interview.fyicenter.com/1808...

How To Set a Persist...

How To Set a Persistent Cookie? - PHP Script Tips - Understanding and Managing Cookies...                                                                          

interview.fyicenter.com/348...

Can BLOCKQUOTE Eleme...

Can BLOCKQUOTE Elements Be Nested? - XHTML 1.0 Tutorials - Body Tag and Block Level Tags...                                                                        

interview.fyicenter.com/1337...

How To Set Up SQL*Pl...

How To Set Up SQL*Plus Output Format? - Oracle DBA FAQ - Understanding SQL DML Statements...                                                                      

interview.fyicenter.com/841...