sql server - Vietnamese characters in sql select like -

when search following query

select * [table] name '%hà nội t&t%'

in mssql database no results, though i'm sure exists in db.

i seem have trouble characters ộ, ẫ, , Đ.

i have tried changing collation-settings nothing helps.

any suggestions?

try:

select * [table] name n'%hà nội t&t%'

KHS