Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Unanswered: Difference between the two create table statements

    Hi,

    I would like to know the difference between the following two
    create table statements.

    Statement 1
    -----

    CREATE TABLE emp (name VARCHAR2(10));

    Statement 2
    -----

    CREATE TABLE emp (name VARCHAR2(10 CHAR));


    Thanks
    nn

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Difference between the two create table statements

    If your character set uses 1 byte per character, they are the same. However, Oracle also supports multi-byte character sets, e.g. for Japanese text; for these, the distinction is important.

Posting Permissions

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