Thursday, 8 August 2013

Cannot update varchar column with special characters

Cannot update varchar column with special characters

Originally i thought that this issue is related to C# TransactionScope or
Dapper.NET. But since i have tested the sql in SSMS and the issue remains
i assume that it's a pure sql issue.
This is the (simplified) update which should update a varchar(40) column.
I don't get any errors and row-count is 1. The old SparePartDescription is
EC801/¦USB/Exch Acc/JP/PE bag:
declare @rowCount int
UPDATE [tabSparePart] SET
[SparePartDescription] = 'EC801/╡USB/Exch Acc/JP/PE bag'
WHERE ([idSparePart] = 13912)
set @rowCount = @@ROWCOUNT
select @rowCount
So the only difference are these special characters: ╡ and ¦.
Maybe you have an idea why i cannot update this column.

No comments:

Post a Comment