Cita:
Iniciado por Libras 
Investiga sobre el uso de collation ;)
usando COLLATE seria algo asi?:
Código SQL:
Ver originalSELECT CAST(Title AS NVARCHAR(900)) AS Title, SubTitle, Initiators, WinningTypeID, WinningType,
RewardTypeID, RewardType, WinningYear, ShortDescription, Initiators, Description, Image1, Image2,
Image3, Image4, InitiatorEmail, InitiativeID, InMemoryOF FROM ViewWebWinningInitiatives
WHERE RewardTypeID = 1
AND WinningYear = '$_year'
AND WinningTypeID = '$_type'
AND Title LIKE N'%$_input%'
ORDER BY Title
COLLATE utf8_unicode_ci
Cita: Editado: Código de programación no permitido en foros de Bases de Datos.
porque no obtengo nada