Language problem

[alamitab]

Hi guys.

Need some help...
We have a CC in Japan and in the strategy after the select from Oracle DB the name of the customer is returned wrong. Seems to be a encoding problem:
Var_Company(LOCAL) <- STRING: � �式会社ヤナセオートシステ� ズ

If is done the select manualy, directly from the client (non genesys) the result is ok.
Example: オートバックス西昆陽

For the Oracle Client NLS_LANG=AMERICAN_AMERICA.UTF8.


Thanks.

[RobertH]

Hi

I had similar problem with OCM and the Slovak language.

The problem is with regional settings of host where the Genesys DB server is running.
If you are running Genesys  DB server at linux/unix/solaris machine you need to set user profile with correct NLS_LANG.

Regards
Robert

[alamitab]

Hi.

If i verify from the server where the db client is installed, all fine:
server.user./opt/USER $ sqlplus user/user@SID
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Aug 3 10:04:53 2011
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options
SQL>@select_name.sql
KUNNR              NAME1
---------------- ---------------------------------------------------------------
0004700773    オートバックス西昆陽

But in URS logs is found this:
Var_Company(LOCAL) <- STRING: � �式会社ヤナセオートシステ� ズ
where Var_Company take ta value of NAME1.

NLS_LANG is  NLS_LANG=AMERICAN_AMERICA.UTF8. In genesys under confserv i've found also
encoding=utf-8. Should be ok but is not ....

Thanks.

[RobertH]

Hello

I think you should set the NLS_LANG = JAPANESE_JAPAN.JA16EUC or some other valid Japanese character set.
Here you can find some tips:
http://itcareershift.com/blog1/2011/02/04/oracle-character-set-everything-a-new-oracle-dba-needs-to-know/
I had to set it to slovak.
After that the characters were stored correctly.
Hope this hepls.

Regards
Robert

[alamitab]

Thanks you for reply Robert.