Outbound Database doesn't display correctly vietnamese characters!

[hieutx]

Hi everyone,

I have a problem when i fill a outbound field on GA With vietnamese Characters. Must I configure OCS or OCS DBServer to support UTF-8?
Pls give me some advise !
Thanks a lot.

[img width=404 height=480]https://i.imgur.com/GKqhnJ4.jpg[/img]
[img width=640 height=304]https://i.imgur.com/xPtqeCT.jpg[/img]

[gen_den]

is your config server configured to support UTF-8 ? and DB?

[hieutx]

Yes, I configured config Server and Outbound DB as follows:

[img width=640 height=29]https://i.imgur.com/hzEuBtC.jpg[/img]
[img width=640 height=16]https://i.imgur.com/sG55GRj.jpg[/img]

[cavagnaro]

When you installed CfgServer, did you use the correct init script? The multi lang one?

[Kubig]

Check the locales of server where the OCS (OCS and related DB Server) is running

[hieutx]

@cavagnaro . Yes i did. I use all multilange scripts to create database.

@Kubig: What should i configure OCS to support utf-8 ?
I tried to configure msql_name=./dbclient_851/dbclient_msql in Outbound DB Server option tab. But it doesn't work.

Thanks a lot

[catanirex]

Did you configure Administrator to handle utf-8?

In the web.config configuration file located in the Genesys Administrator installation directory, insert the following line:

<add key="PSDKEncoding" value ="UTF-8"/>

Also, there is a document on Genesys web site describing how to set Genesys up to handle mixed languages:

https://docs.genesys.com/Documentation/MixedLangWP

[Kubig]

Also use the latest GA where you can also define the PSDKEncodingDB - for further details follow documentation and release notes

[hieutx]

@catanirex: I tried to configure both Config Server and GA as intructions in "https://docs.genesys.com/Documentation/MixedLangWP" . But it doesn't help. In DB Table, I changed Colume type from VARCHAR  to Nvarchar and tried insert directly to DB Table. It worked well. But when update via GA. It still get errors 

[Kubig]

Let me quote release notes for GA:

[quote]New in This Release

There are no restrictions for this release. This section describes new features that were introduced in this release of Genesys Administrator.

Manual override of Configuration Server and Database encoding settings: You can now force Genesys Administrator to use UTF-8 encoding when interpreting data in Configuration Server, and in any DBMS to which it connects directly, such as an Outbound Contact database.

By default, Genesys Administrator uses Configuration Server’s multi-language mode to determine whether to switch to UTF-8. By using the following new options in the Web.config file, you can configure Genesys Administrator to work in non-standard environments where, for legacy reasons, UTF-8 might have been used outside of multi-language deployments introduced with Management Layer 8.1.3.

PSDKEncoding
Default Value: No default value
Valid Values: utf-8
Changes Take Effect: After IIS restart

Specifies the encoding used by Configuration Server. If this option is not set, the encoding used is based on the language mode (single- or multi-language) used by Configuration Server. When this option is set, Genesys Administrator uses the encoding specified in the Web.config file when handling configuration data, ignoring the Configuration Server language mode.

PSDKEncodingDB
Default Value: No default value
Valid Values: utf-8
Changes Take Effect: After IIS restart

Specifies the encoding used for interpreting database data. If this option is not set and PSDKEncoding is also not configured, the encoding used to handle database data is based on the mode (single- or multi-language) used by Configuration Server. If PSDKEncoding is set, and PSDKEncodingDB is not set, database data is interpreted based on PSDKEncoding data. If PSDKEncodingDB is set explicitly in Web.config, this value will be used when handling all database-bound data, regardless of any other settings or Configuration Server mode.

Notes:

Make sure that the encoding is the same for the database, the database client, and Genesy Administrator.
A typical deployment will not require you to set either of these options. Use them only if instructed to do so by Genesys Customer Care.[/quote]

[hieutx]

Hi Kubig,

I tried to set both 2 options but it doesn't help.

[code]PSDKEncoding
Default Value: No default value
Valid Values: utf-8
Changes Take Effect: After IIS restart

PSDKEncodingDB
Default Value: No default value
Valid Values: utf-8
Changes Take Effect: After IIS restart[/code]