DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Diff between Char and Varchar2

  1. 01-13-2003, 12:46 AM #1
    sethi_kapi
    sethi_kapi is offline Junior Member
    Join Date
    May 2002
    Posts
    22

    Question Diff between Char and Varchar2

    Hello Everyone
    I want to know the difference between Char and VARCHAR2 data types.I know that CHAR is fixed width and VARCHAR2 is variable width.but i want to know if VARCHAR2 can provide what CHAR can provide then why should i use CHAR.Is there any big advantage of using CHAR over VARCHAR2?
    Reply With Quote Reply With Quote
  2. 01-13-2003, 09:29 AM #2
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    Comparison Semantics
    Use the CHAR datatype when you require ANSI compatibility in comparison semantics (when trailing blanks are not important in string comparisons). Use the VARCHAR2 when trailing blanks are important in string comparisons.

    http://download-west.oracle.com/docs...typ.htm#417955
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width