OraFAQ Forum: Client Tools » Importing Hebrew, using ODBC from Excel

Home » Other » Client Tools » Importing Hebrew, using ODBC from Excel (SQL Developer, 4.0.2, Windows 7 Professional, 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Importing Hebrew, using ODBC from Excel [message #626513 is a reply to message #626511]

Tue, 28 October 2014 09:02

Analyst
Messages: 45
Registered: June 2014

Member

But in ERP itself I see it in Hebrew.
In order to see Hebrew, in my queries (from ERP DB directly) I use the following workaround:

Utl_i18n.raw_to_nchar(Utl_i18n.string_to_raw(ITEMS.LOCAL_NAME),'IW8MSWIN1255') as ITEM_NAME2.

But when I try using this workaround with database link, it doesn't help.
Do you have any suggestions for it?

[Updated on: Tue, 28 October 2014 09:03]

Report message to a moderator

Re: Importing Hebrew, using ODBC from Excel [message #626516 is a reply to message #626513]

Tue, 28 October 2014 09:06

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Garbage in garbage out.
The solution is to use a proper character set.

Report message to a moderator

Re: Importing Hebrew, using ODBC from Excel [message #626517 is a reply to message #626513]

Tue, 28 October 2014 09:06

Analyst
Messages: 45
Registered: June 2014

Member

I mean, when I query ERP DB directly:

Select Utl_i18n.raw_to_nchar(Utl_i18n.string_to_raw(ITEMS.LOCAL_NAME),'IW8MSWIN1255')  as ITEM_NAME2
From ITEMS;

I see Hebrew well:

פריט לביטול עיסקאות

When I query it with db link (in order to store in my DB):

Select Utl_i18n.raw_to_nchar(Utl_i18n.string_to_raw(ITEMS.LOCAL_NAME),'IW8MSWIN1255')  as ITEM_NAME2
From ITEMS@ERP_ANALYST;

I have a problem:

[code]ôøéè ìáéèåì òéñ÷àåú[code}

Report message to a moderator

Re: Importing Hebrew, using ODBC from Excel [message #626518 is a reply to message #626517]

Tue, 28 October 2014 09:07

Analyst
Messages: 45
Registered: June 2014

Member

Where do I have to use correct character set?
I can't change the character set of external ERP.

Report message to a moderator

Re: Importing Hebrew, using ODBC from Excel [message #626522 is a reply to message #626518]

Tue, 28 October 2014 09:30

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I can't change the character set of external ERP.

This one is incorrect so you have to use workaround to see the data.
Your environment is a total mess, you have to make tests and tests and tests to finally find the workaround you can use to get what you want.
I can't make these tests for you.
Play with the different parameters you can find around character sets as we did.

Report message to a moderator

Re: Importing Hebrew, using ODBC from Excel [message #626523 is a reply to message #626522]

Tue, 28 October 2014 09:33

Analyst
Messages: 45
Registered: June 2014

Member

I understand, I will do.
Thank you very much.

I will play with NLS_LANG value in registry. What values could I play with besides it?
Would adding environment variables NLS_LANG and NLS_CHARACTERSET be useful?

Report message to a moderator

Pages (2): [ « ‹ 1 2]

Previous Topic:	SQL DATA MODEL IS NOT ENABLE!?
Next Topic:	Problem with Arabic language

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:01:40 CDT 2024