Question marks appear instead of arabic characters after data migration between sql server and oracle!!

Posted on 2008-11-09
Last Modified: 2013-12-19
Hi all,
i'm using SSIS to migrate data from an SQL Server DB to an Oracle DB, everything goes fine except the question marks that appear instead of the arabic characters when data is moved to the oracle tables!!

NLS_Lang entry in the oracle DB is:

NLS_Lang entry for the oracle client thats on the SQL Server is exactly the same, any suggestions?!

thanks alot in advance !

Question by:farahwj

    Author Comment

    NLS_NCHAR_CHARACTERSET for the Oracle DB is: AL16UTF16
    LVL 17

    Accepted Solution

    In SSIS you can choose the Column Code Page for each connection. Have you done this? What did you choose for SQL Server, for Oracle?
    Here is a Transform tool from MS.
    Another good reference for this issue:

    Author Comment

    >>In SSIS you can choose the Column Code Page for each connection. Have you done this? What did you choose for SQL Server, for Oracle?

    Author Comment

    i have downloaded and installed the tool successfully but i still need your help with using it, i have the following 2 test tables:
    a table named groups in sql server and it has the following structure;
    id                      nvarchar(50)
    arabicdesc     nvarchar(200)
    englishdesc   nvarchar2(200)
    ABRV                nvarchar2(50)
    flag                    int
    the equivalent oracle table is as follows:
    desc groupstest
     Name                                                  Null?    Type
     ----------------------------------------------------- -------- ----------------
     CODE                                                           NVARCHAR2(50)
     EDESC                                                          NVARCHAR2(200)
     ADESC                                                          NVARCHAR2(200)
     ABRV                                                           NVARCHAR2(50)
     FLAG                                                           NUMBER(1)
    in your reply you stated that i can choose the Column Code Page for each connection
    , i didnt know from where!!
    how can i use the tool with these 2 tables i described above?

    Author Comment

    ok it worked, i put  code page 1256 for both the sql server connection and the oracle connection, and same to CodePageConvert tool and set its converttounicode property to false :) thanks alot HoggZilla!

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how the fundamental information of how to create a table.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now