BodyString column shows Chinese characters

I have the same issue described here.

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

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

Any idea what the problem could be?

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;

Followed by:

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

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

1 Like

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

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

1 Like