How to extract data from SQL database with nvarchar fields?

[ben.fuller]

I am writing a script that needs to pull data from the cra database (such as agent ext.) but when attempting to configure a DB Get, the Data Type comes up as unsupported? Is there a way to extract information stored in a nvarchar field? Can I change the extension field type to varchar (which is supported by CRA Editor) in the Resource Table without affecting the operation if ICD?

Any ideas appreciated!

Thanks,

Ben

[owillins]

Since NVARCHAR is not supported, you could find a way to change this variable to VARCHAR which is supported. The other option you have is to write a custom class to access this data type from a SQL Server database using Java.