NVARCHAR2 or VARCHAR2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: NVARCHAR2 or VARCHAR2

  1. #1
    Join Date
    Jan 2000
    Location
    Manama, Bahrain
    Posts
    50
    I would like to know how to use these datatypes.
    Each table in our database will have arabic as well as english data stored in it.
    Is it ok to use VARCHAR2 only or do i have to declare the arabic columns as NVARCHAR2.

    Will there be a change in the way the tables are queried?

    Thanks
    Lynn

  2. #2
    Join Date
    May 2001
    Location
    BANGALORE
    Posts
    5
    hi

    I hope arabic is asian language so it is multibye charcter
    set .so it ocuppies double of the space ..so u put comman
    as NVARCHAR2 if u r geting data for arabic.

    bye
    Ram Aluri

  3. #3
    Join Date
    May 2001
    Posts
    14
    My understanding is varchar2 can support variable multibyte characters . Nvarchar can only support fixed.
    So if you many languages then varchar2 is better
    Experienced users please agree/disagree

  4. #4
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    Hi,

    NCHAR: - A standard Oracle datatype. The NCHAR datatype specifies a fixed-width national character set character string, and can have a maximum column size up to 2000 bytes.

    NVARCHAR2 datatype
    A standard Oracle datatype. The NVARCHAR2 datatype specifies a variable-length NCHAR string. NVARCHAR2 width specifications refer to the number of characters if the national character set is fixed-width, and to the number of bytes if the national character set is varying-width. The maximum column size allowed is 4000 bytes.

    VARCHAR2
    An Oracle Corporation datatype. Specifically, it is a variable-length, alpha-numeric string with a maximum length of 4000 characters. If data entered for a column of type VARCHAR2 is less than 4000 no spaces will be padded; the data is stored with a length as entered. If data entered is more than 4000, an error occurs.

    From the above definitions of the different type of datatypes comparison, i would suggest u to use the NVARCHAR2 datatype if u r getting in the defined chacterset (arabic) data in that column ...

    Isaad@rediffmail.com

Posting Permissions

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


Click Here to Expand Forum to Full Width