String variable of Unicode characters problem

[samhopealpha]

Hi all

I define a variable named "vRemoteParty" ... with String type

in order to store the return value of "7748"

I got the following result via the UCCX debugger ...

Result: U"\u3737\u3834"

suppose it is result: 7748 ...

So. how can I convert this unicode character in UCCX script??

I tried the String.valueOf() but seems not working

Anyone could help

Thanks

Sam

[samhopealpha]

I found that the problem only existed while connected to MySQL database

The STRING returns correctly if querying with Microsoft SQL.

Does it mean the UCCX does not support MySQL??

or there is any setting should be changed in MySQL or UCCX

Thanks

Sam

[jtp777001]

I'm not sure if this is helpful but Unicode digits start at 30 for 0 and end at 39 for 9. Given that the Latin alphabet ends at 7A, there may only be support for two hex digits. That would make the output of \u3737\u3834 the number 7784. If the return value is always a number you may want to store it as an int.

Edit:

After looking at it more, the \uxxxx notation is for a char type literal.