sql server - SQL LIKE with special characters -

If I try to create a selection with special (Nordic) letters:

 < Code> Select * from users where the name is like '% æ%'  

This simply selects all users instead of letters 'æ'.

Do I need to install something special driver in the database, or something else I miss?

Update:
I am using a SQL Server 2008 database, the collation is set to 'SQL_Latin1_General_CP1_CI_AS' and the datafield is an empty NVarChar datatype.

Most likely some collation or datatype issue

example gives 97 And 230

  SELECT ASCII ('æ' COLLATE Albanian_CI_AI), ASCII ('A' collet Latin 1_General_CI_AS)  

We basically need more information Will be. Edit: (Though unresolved)

Editing 2: If the name is nvarchar, then change this code so that there is also a literal Unicode. Choose from

  select * where the name 'N'% æ% ''