Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: alamitab on July 26, 2011, 01:43:55 PM

Title: Language problem
Post by: alamitab on July 26, 2011, 01:43:55 PM

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.

Title: Re: Language problem
Post by: RobertH on July 29, 2011, 08:52:57 PM

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

Title: Re: Language problem
Post by: alamitab on August 03, 2011, 08:12:50 AM

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.

Title: Re: Language problem
Post by: RobertH on August 04, 2011, 06:57:18 PM

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

Title: Re: Language problem
Post by: alamitab on August 23, 2011, 03:05:12 PM

Thanks you for reply Robert.