mssql select with LIKE utf-8 - Cyrillic_General_CI_AS

I'm working with PHP/MSSQL all select queries work fine, but when I try to SELECT with LIKE '%строка%' it doesn't retrieve any data开发者_如何学Python - PHP files in utf8 and MSSQL in Cyrillic_General_CI_AS? Please help, there weren't any forums helpful.

You can try to specify the collation in the query. It is hard to figure out from your question what the correct collation is, but this will give you the idea.

SELECT *
FROM Table1
WHERE Column1 COLLATE Cyrillic_General_CI_AS LIKE '%строка%'