Unicode without the N

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 25
Joined: Tue 15 Aug 2006 01:25

Unicode without the N

Post by rhettp » Wed 15 Dec 2010 16:48

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.




Post by AndreyZ » Thu 16 Dec 2010 09:18


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.

Post Reply