Skip to Content
author's profile photo Former Member
Former Member

code page issue in data services source oracle and trgt bods data store

Dear Experts,

I am facing issue with Arabic text, I have source as Oracle and Target as Data Service Data Store.

When I am seeing in Sql Developer Tool, I could able to see the Arabic texts in the columns where it is given as Arabic, but when I am "View Data" in data store in data services, Its all coming as ??????????? (reverse question marks).

Even I tried to load in template table by making the Options->Miscellaneous->"Use NVARCHAR as VARCHAR columns in supported database"

but still the error is coming.

I tried to change the Language : ARABIC and CODE PAGE: CP1252,CP1256, CP1257, UTF-8 and all other options but still I could not able to see the ARABIC texts in Datastore "View Data" and target table.

I also tried to change the option in Tools->Options->Designer->Language "Preferred Viewing Language" to Arabic, but nothing is working.

Can you experts, suggest me how to resolve this issue.

Thanks,

A Sustainer

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2015 at 06:27 AM

    Hi Experts,

    Can any one put in their views and suggest me for a solution for this issue.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.