[cvsnt] Re: Help with Audit

[Clovis Garcia]

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