In the documentation for v1.2, the MS SQL Server example for
ADONetAppender has a misleading table creation script. The table should
create nvarchar columns instead of varchar columns because the DBType
parameters in the configuration are set to "String". String is a unicode
(i.e. nvarchar) format.
The table creation script should read:
CREATE TABLE [dbo].[Log] (
[Id] [int] IDENTITY (1, 1) NOT NULL,
[Date] [datetime] NOT NULL,
[Thread] [nvarchar] (255) NOT NULL,
[Level] [nvarchar] (50) NOT NULL,
[Logger] [nvarchar] (255) NOT NULL,
[Message] [nvarchar] (4000) NOT NULL,
[Exception] [nvarchar] (2000) NULL
)
This example can be found here:
http://logging.apache.org/log4net/release/config-examples.html#HC-125907
45
You could also change the related /appender/parameter/[EMAIL PROTECTED]
attribute to 'AnsiString' instead of 'String.
Hope this helps,
Eric
This e-mail and any files transmitted with it are confidential and are intended
solely for the use of the individual or entity to whom they are addressed.
This communication may contain information that is protected from disclosure by
applicable law. If you are not the intended recipient, or the employee or
agent responsible for delivering this communication to the intended recipient,
be advised that you have received this e-mail in error and any use,
dissemination, forwarding, printing or copying of this e-mail is strictly
prohibited. If you believe that you have received this e-mail in error, please
immediately notify Edgewater Technology by telephone at (781) 246-3343 and
delete the communication from all e-mail files.
