Cyrillic characters · Serbian characters in sql server 2005
-
hi, I was trying to update the Cyrillic characters · Serbian characters in sql server database, but everytime i shows ??? after updation Please suggest something. Thanks
Do you use VARCHAR or NVARCHAR? Only NVARCHAR will do!
-
Do you use VARCHAR or NVARCHAR? Only NVARCHAR will do!
-
Thanks for replying... If I have to search for keyword abcurlф in the table what should be the query in this case? Presently it is not displaying any result if i search even only with ф and displays those records which have ? character
In the Employees table of Northwind database, I changed the FirstName of an entry to "abcurlф". Now I do in SQL Enterprise Manager:
SELECT *
FROM Employees
WHERE (FirstName LIKE N'%ф%')and that returns exactly the row where I made that change. Note that an "N" is required before the search term -
LIKE '%ф%'does not work.