[cvsnt] Re: Help with Audit

[Clovis Garcia]

Bo,

Sorry but I´m using Thunderbird to read the news and when your answer 
came with the [cvsnt] before the title it didn´t put it at the same 
thread so I didn´t see the other messages. Another information about 
this issue is that all the times that a foreign character should appear, 
it and the next 2 characteres are replaced by ?.

Gerência -> Ger?ia


Regards,
Clóvis



On 15/2/2006 12:13, 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...
> 
> Otherwise I would have made a change, compiled and tested already. 
> 
> 
> Best regards,
> 
> Bo Berglund
> 
> 
> -----Original Message-----
> From: cvsnt-bounces at cvsnt.org [mailto:cvsnt-bounces at cvsnt.org] On Behalf Of Clovis Garcia
> Sent: den 15 februari 2006 15:26
> To: cvsnt at cvsnt.org
> Subject: Re: [cvsnt] Re: Help with Audit
> 
> Bo,
> 
> 
> I did the same you said. I used the CVSNT panel to enable the plugin and 
> filled the boxes with the information required. Nothing has been done 
> manually but I´ve checked that the Message and Diff columns were defined 
> as text. I´ve changed it now but the Directory column was already 
> defined as nvarchar and the problem was happening with it too.
> 
> I did a trace to check the commands sent to the database by CVSNT and 
> noted that the messages was already sent with the errors.
> 
> If there is another thing to check let me know, but I say in advance 
> that I just enabled the plugin, filled the boxes and continued to use 
> the CVS normally.
> 
> Regards,
> Clóvis
> 
> 
> 
> On 15/2/2006 05:48, Bo Berglund wrote:
>> Are you really sure that ODBC is used for MSSQL/MSDE?
>> When I set this plugin up I do not create an ODBC entry, I just 
>> enter the login data directly in the boxes...
>>
>> Looks to me that you might be using ADO for the MSSQL database 
>> engine, or are you creating the ODBC entry automatically in the 
>> background? 
>>
>> Concerning unicode storage in MSSQL database tables:
>>
>> 1. The tables *must* be defined as holding nvarchar or ntext data.
>>    If I look in my copy of create_tables_mssql.sql I see that all
>>    text columns are just plain text, not ntext as they should be.
>>    That's the Message and Diff columns.
>>
>> 2. When sending a query to insert or update the columns with text
>>    data the actual string must be preceded by N as in:
>>    UPDATE CommitLog SET Message = N'text data goes here' WHERE bla bla
>>    And of course any single quote ' inside the message itself has
>>    to be doubled to not cause an SQL problem
>>
>>
>> Best regards,
>>
>> Bo Berglund
>>
>>
>> -----Original Message-----
>> From: cvsnt-bounces at cvsnt.org [mailto:cvsnt-bounces at cvsnt.org] On Behalf
>> Of Tony Hoyle
>> Sent: den 14 februari 2006 23:45
>> To: cvsnt at cvsnt.org
>> Subject: [cvsnt] Re: Help with Audit
>>
>> Bo Berglund wrote:
>>> Tony,
>>> which sourcefile is used to fill the commitlog database entries?
>>> Are you using ADO to access the MSSQL database or some other means?
>>>
>> ODBC, using unicode to send it to the database (so should be universal).
>>
>> It's possible your database isn't configured to store the extra 
>> characters... can't remember what I did last time to store foreign 
>> characters in MSSQL.
>>
>> Tony
>> _______________________________________________
>> cvsnt mailing list
>> cvsnt at cvsnt.org
>> http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt
> _______________________________________________
> cvsnt mailing list
> cvsnt at cvsnt.org
> http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt