c# - SQL Server query not finding row in Database -


i have row in sql server database :

province    city                                locationtext ------------------------------------------------------------------------------- İstanbul    İstanbul sabiha gökçen havalimanı   Ä°stanbul sabiha gökçen airport 

and copy & paste city name above test in query below:

select *  locations  city ='İstanbul sabiha gökçen havalimanı' 

but query returns no result found. missing here?

if it's nvarchar column, might have better luck n prefix:

select * locations city = n'İstanbul sabiha gökçen havalimanı' 

here's microsoft support article describing use of n prefix when dealing unicode values.


Comments