Home Forums SQL Server 2005 Working with Oracle Junk arabic details while transfer arabic data from sql server 2000 to oracle RE: Junk arabic details while transfer arabic data from sql server 2000 to oracle

  • Install ODBC Drivers and configure odbc.ini file in that we set parameter IANAAppCodePage=106 . Sample odbc file below:

    [MSSQL]

    Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so

    Description=DataDirect SQL Server Wire Protocol driver

    Database=<dbname>

    LogonID=<username>

    Password=<password>

    Address=IP Address,1433

    QuotedId=No

    AnsiNPW=No

    IANAAppCodePage=106

    And check from ur application from where u r not getting Arabic Data, if need some changes do changes in ur application . The IANAAppCodePage=106 condtains code page 106 is nothing but UTF-8 code that v set in odbc file to get Arabic data and if required some changes like using code page in our application.

    Enjoy : :smooooth::smooooth::smooooth: