Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Bo, The INSERT command is already using de designator N before the column Message, but the problem persists. I think the text is been corrupted before the call of the command because the Trace shows the text already changed. Clóvis On 15/2/2006 13:38, Tony Hoyle wrote: > Bo Berglund wrote: >> Clovis, >> my response was really directed towards Tony rather than you. >> He is the one who can check what is going on in the plugin. >> >> We are using MSSQL in our products and we found that the queries >> that put textual data into the database *must* specify the unicode >> designator N in front of the string parameter being sent to the >> server. We solve this transparently in our case by using a class >> method to create a SQL compatible parameter string so we need not >> bother ourselves to do this. The CVSNT audit plugin is unfortunately >> written i C++ so I cannot do anything about this since I cannot >> untangle the code at all... >> > That kinda sucks. In theory though it shouldn't matter so much - it'll > just take the unicode string it's passed and covert it to the database > ANSI codepage first... which isn't particularly fatal if the database > supports the characters you are using.. it's just a bit stupid that's all. > > Tony