BodyString column shows Chinese characters

,
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?

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.

1 Like
3

after changing the schema as mentioned above I’m getting human readable json, but I also get the expected json prefixed by some special characters. Is this the way it should be?

getting {“Value”:5} where I would only expect {“Value”:5}
just want to be sure everything is alright

4

This it the UTF8 BOM, this is sometimes added by serializers.

1 Like