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, 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 cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook > 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 cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook >> 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 cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook >> http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt https://www.march-hare.com/cvspro/en.asp#downcvs > _______________________________________________ > cvsnt mailing list > cvsnt at cvsnt.org cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook > http://www.cvsnt.org/cgi-bin/mailman/listinfo/cvsnt https://www.march-hare.com/cvspro/en.asp#downcvs