Select's Where Clause - Non Ascii Characters?

I'm having a problem with non-ASCII chara开发者_如何学运维cters in a where clause

Say for example a record in my table has :

column_a Bom D� Street

And I want to see if this will find the record:

SELECT * FROM [tbl_test] where column_a = 'Bom D� Street'

This always returns no records.

Is there something you have to do to handle non-ASCII characters?

Try this: SELECT * FROM [tbl_test] where column_a = N'Bom D� Street'

This should treat the string as unicode and support the full extended character set.