I am trying to replace a Unicode block character in my sql server db. It shows up on my web site as U+FFFx (Question Mark inside of a rhombus) on my classic asp website but looks like a space in my db. I have tried to Trim the fields and I have tried to replace the space, the symbol. I would really like to get these out of there.
Any help would be much appreciated.
DECLARE @tst nvarchar(10) = N'╔ẊṼ∑╗' -- possibly not displayed correctly at EE
DECLARE @vb varbinary(20) = 0x54258A1E7C1E11225725 -- varbinary representation of the above Unicode string
DECLARE @vb2 varbinary(20) = 0x54258A1E7C1E11225725FFF1
SELECT @tst, @vb, CAST(@tst AS varbinary), CAST(@vb AS nvarchar), CAST(@vb2 AS nvarchar)
Update: EE knows how to display Unicode. This was not true in the past... +1 for EE!
SELECT * FROM YourTable WHERE CHARINDEX(CHAR(160), YourColumn) > 0