winformssql-server-2005fontswingdings

Wingding chars in sql server 2005

In a winforms application i 'm storing one Wingdings char in a SQL Server 2005 field of type NVARCHAR(1).

Storing, retrieving and showing up this char in a control works fine.

The problem i'm facing is this: how to search for records which have a specific wingding char value: for example

Select * from table where FieldWithWingding = valueOfLeftArrowChar

How to achieve this?

Thanks in advance

Solution

  • Igor pointed me into the correct direction: it's actually

    Select * from table where FieldWithWingding = N'ß'

    Works fine!

    Thank you everybody!