I'm using a search function like this:
But when searching Turkish characters like ş or ç this function doesn't work. For example, there is a title named "Aşçi". My search string is like search.asp?query=asci (it converts Turkish characters to English characters). But it doesn't find it. I want to find "Aşçi" when I search for "asci". How can I make this?Code:
sql = "select * from table where title like '%" &trim(query)&"%' order by id desc"