BodyString column shows Chinese characters

sql-persistence
nservicebus

(Jerry Joseph) #1

I have the same issue described here.

var transport = endpointConfiguration.UseTransport<SqlServerTransport>();
transport.CreateMessageBodyComputedColumn();
endpointConfiguration.UseSerialization<NewtonsoftSerializer>();

When I script the table I get [BodyString] AS (CONVERT([nvarchar](max),[Body])

Any idea what the problem could be?


(Ramon Smits) #2

This is a non critical bug in the SQL Transport table schema:

You can fix this manually by updating the schema:

Please do the following:

ALTER TABLE [MyQueueTable] DROP COLUMN BodyString;
GO

Followed by:

ALTER TABLE [MyQueueTable] ADD BodyString as cast(Body as varchar(max));
GO

This is a non critical issue and will be fixed in the next maintenance release for the SQL transport.