Unicode without the N

[rhettp]

Is there a way to automatically have an N inserted for Unicode with SDAC? Or is there a way to parse the SQL in an event before it hits the database? That way I could at least try and write a handler that auto-tacks on the N character for Unicode support with manual insert statements and MSSQL Server.

Thanks,

Rhett

[AndreyZ]

Hello,

When you execute plain SQL code, SDAC transfers it to SQL Server as it is. In this case you should create your SQL code with already inserted "N" symbol for Unicode columns. But the better way is to use query with parameters. This way you can avoid the problem.