Auto prefix 'N' for unicode string literals?

[GMG]

We have a lot of code we have to make compatible with SQL Server Unicode, and prefixing all string literals with 'N' is one of the required changes.

Is this by any chance something the can be done behind the scenes by the DevArt drivers, say, using a connection parameter?

I don't see any in the documentation, but I thought it would be worth a check.

Thanks very much!

[Dimon]

DbxSda supports Unicode. To use Unicode you should set the proper parameter of TCRSQLConnection to True, like this:
TCRSQLConnection.Params.Add('UseUnicode=True');

[GMG]

Thanks. I had this in the initialization, and unicode parameters work fine, but SQL without parameters like this do not:

update table set col='CHINESE TEXT'

-- select shows '?????????'

update table set col = N'CHINESE TEXT'

-- select shows 'CHINESE TEXT'

So, we have to update our SQL to add the N.

Correct?

Thanks again for the help.

[Dimon]

Yes, it is right.