Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40

    Exclamation Unanswered: Size of nVarChar

    Hi there,
    I got a problem while migrating a SQL Server database to Oracle 9i, there are fields defined in SQL Server as nChar & nVarChar, which supports almost 4000 charcaters while in Oracle the nVarChar only supports upto maximum of 2000 charcaters.
    Can you guide me please..
    Thanking you in anticipation..
    RGDS
    Amit

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    wrong.

    example:
    PHP Code:
    goldoltpcreate table x (a varchar2(4000));

    Table created
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40

    Exclamation Migration problem from SQL Server to Oracle

    Hello Mr. Duck,
    First of all thanks for ur reply. But I am really very sorry to say-
    I think u had not go through the problem I had stated.
    1- It is regarding nVarChar not with Varchar.
    2- It is related with the migration of database from SQL Server to Oracle.
    where SQL supports 4000 bytes for nChar & nVarchar whereas Oracle only supports 2000 bytes of nChar & nVarChar.
    So plz guide me over this issue.
    RGDS
    Amit

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Code:
    Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.3.0 - Production
    
    SQL> create table x (y nvarchar2(4000));
    
    Table created.

Posting Permissions

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