Wingding chars in sql server 2005

Question

Hi everybody!

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

Answer 1

Wingdings is a font! Fonts give a special appearance to characters in a given character set. The left-arrow is therefore a character. Look it up in start->all programs->Accessories->System tools->Character map

Your select will be something like:

Select * from table where FieldWithWingding = 'ß'

Answer 2

Try this: select Unicode(N'ß'), Nchar(Unicode(N'ß'))

Use @filter nvarchar(1) or nchar(1) data types

Answer 3

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

Select * from table where FieldWithWingding = N'ß'

Works fine!

Thank you everybody!