UCCX 8.0 - DB Get step is returning Unicode value instead of string

[sferland]

One of my customer is in the process right now to migrate his system to version 8.0.

We are using database queries to MS-SQL within the scripts. Last friday, during our tests with the new system, we realized that the mapping of a database varchar to a java.lang.String (with DB Get step) is giving us a bunch of Unicode character instead of the correct String value.

Ex: One of the value is for the business hours : 0800-1200,1300-1700

In the local variable, after the script executed the DB Get, we got : U"\u3830\u3030\u312D\u3032\u2C30\u3331\u3030\u312D\u3037\uFFFD"

Attached pictures are :

db_record_vs_local_variables_mapping.JPG : DB Get mapping

table_heuresfiles.JPG : Value in MS-SQL

getHours.JPG : Values of the local variable after DB Get step is executed

Anyone already experienced this behaviour ???

[sferland]

Found my problem.

For those interested, I changed the Data Type for all my String in the Database from "NVARCHAR" to "VARCHAR" and then add the following property into the JDBC URL :

;charset=ISO-8859-1

[TBerwart]

Hello,

after changing the connection url with the charset, do we have to restart the CCX Engine ?
or is it not needed ?

Kind regards,
Thierry

[Roger Kallberg]

I do not believe that it would be necessary.

[shh5455]

There is a bug starting in 8.0 (and still exists in 8.5) where DB Read/Get/Write steps do not work properly from upgraded scripts.  They return unicode or garbage.  You must delete those steps in the script and rebuild them back just as they were.  Then save, upload, and test.

Hope this helps someone.