Our client has an MS SQL database where CCX needs to read certain data, like email addresses, etc.
We get Unhandled data type error when trying to read nvarchar(max) data from the DB.
UCCX is the latest version SU3 - System version: 12.5.1.11003-511 which supports the clients SQL version according to the Compatibility Matrix.
When I run the Reactive debug I get a popup saying 'Unhandled Data type'
I also tried to read a different entry which is not nvarchar, but a simple datetime data field, or varchar, and I was able to get that out, to a string variable properly, so the DB connection works just fine.
As I work in the script editor the script already encounters this problem, but it lets me push apply and OK, and I can test with it, but as stated above, it does not work.
Our problem is, that varchar only supports English and non-unicode type, but we need Hungarian character sets, and with utf-8 encoding.
Does somebody know any workarounds with this problem?
EDIT: Also we found this same problem 18 years ago here:
https://community.cisco.com/t5/contact-center/ipccx-sql-nvarchar-type/td-p/457676
