ODBC connectivity problem

Server: Windows Server 2008R2 SP1
ODBC-Driver Oracle 11g
Filemaker Server: 12

Client : Filemaker 12

Using Filemaker with ESS (external sql sources) and working with data from Oracle DB umlaut (special char "ü") get's lost.
The encoding on the Oracle DBs is "american_america.we8iso8859p1"

What settings can be changed in order to avoid the loss of special chars?
LVL 11
AcklesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AcklesAuthor Commented:
It's quite Urgent!
0
lisfolksCommented:
Might this work? It's from Problem with ODBC (Oracle) and "German umlaute" - Google Groups

- Set NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 in the registry (the same value as the Oracle database has)

- Set the system environment variable NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
0
lisfolksCommented:
Other possibilities include ensuring that you're using UTF16 and a font that can support the umlaut characters.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

AcklesAuthor Commented:
Hi,
sorry for delay, however I don't have any System Variable set.

Could you please tell me what should be the exact variable to be set?

A
0
lisfolksCommented:
The environment (system) variable to set is NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1

Set it to the same value you set for the registry version (the same that Oracle is using).

If that environment variable doesn't exist, you'll have to create it.
0
AcklesAuthor Commented:
Can you please have a look at the example below & tell me what are the two lines I am looking for?

https://kb.wisc.edu/cae/page.php?id=24500

A
0
lisfolksCommented:
1) First, per the article I provided, you would do this select in Oracle:
SELECT * FROM NLS_DATABASE_PARAMETERS
Look for NLS_CHARACTERSET, and note it's value. (Example: WE8ISO8859P1)

2) Next, in the Windows registry go to:
HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE > Key..home..

Look for an entry called NLS_LANG.  The first part is a language indicator, and the second part indicates a character set. This character set value should match the database's NLS_CHARACTERSET value. If they don't match, then change the registry entry to match the database's value.
Example that might appear in the registry: GERMAN_GERMANY.WE8ISO8859P1
GERMAN_GERMANY is the language indicator, and WE8ISO8859P1 is the character set. This character set is the part that must match the database's NLS_CHARACTERSET value.

3) Then, look for an NLS_LANG environment variable, and see if it matches the NLS_CHARACTERSET value you found in the Oracle select results.

If the environment variable doesn't already exist, then:
In the "Variable name" box, you would put: NLS_LANG

In the "Variable value"  box, you would put the same value  that is now in the registry (such as: GERMAN_GERMANY.WE8ISO8859P1) - again, with the character set matching the database value.

If the environment variable does exist, but it's value is different, then change it to match the registry entry.

The main point is that the NLS_LANG character set values in the database, registry, and environment variable must all be the same.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.