Issue with Dynamic SQL and Unicode characters

Hello,

I am looking for help regarding the use of dynamic SQL and Unicode strings.

I am working on a large application, which has been around for 15 years or more. This application has lots - many thousands - of dynamic SQL statements that are built and run with the Execute Immediate command.

An example of one of these statements is:

"UPDATE tbl_xyz SET is_created = 'Y' WHERE xyz_code = 'ALPHA'"

We are now investigating the support of Unicode data and have come to realize that SQL Server, our DB of choice, requires an N before the string.

Our database needs to support English, Portuguese, French, Spanish and Russian characters, so the datatypes being used are "nchar" and "nvarchar".

This would be an enormous undertaking if the only solution is to modify each and every one of these statements, along with any similar statements used by CreateFromSQL statements. As I said there are many thousands of these statements.

Has anyone else encountered this situation, and found a way to resolve it?

Using PowerBuilder 12.5 build 2511

and SQL Server 2008, 2012

Thanks,

Heather Homeniuk