Cyrillic characters · Serbian characters in sql server 2005
-
hi
SELECT *
FROM Employees
WHERE (FirstName LIKE N'%ф3rcwvcwvcehveivewiuvgetiugheiheiogheighetighiogheioghioegheiowghioghi
oetjehbvjwebvjefbvjefbvjhebvfjkwbejkfbvjhebvjewbvbevjkewkjvjevfw
jhevfjhebvjefbvejwkfbvewjvbejwbvjefbvjewbvfjkebvjkefvbjefvbjefbvefw
ewvhbewjvbejvbejvfbejfvbjehfvbjewfbvjwefvbewjfvbejhvfbjkevbjhefbvefb
ewkljhvewfvekfjvekfvewkljfbvkejfvbkefbvkewfv%')In the above query, I have more than 128 characters to search in like predicate, what should be in this case ? and the error message is The identifier that starts with is too long. Maximum length is 128.
-
hi
SELECT *
FROM Employees
WHERE (FirstName LIKE N'%ф3rcwvcwvcehveivewiuvgetiugheiheiogheighetighiogheioghioegheiowghioghi
oetjehbvjwebvjefbvjefbvjhebvfjkwbejkfbvjhebvjewbvbevjkewkjvjevfw
jhevfjhebvjefbvejwkfbvewjvbejwbvjefbvjewbvfjkebvjkefvbjefvbjefbvefw
ewvhbewjvbejvbejvfbejfvbjehfvbjewfbvjwefvbewjfvbejhvfbjkevbjhefbvefb
ewkljhvewfvekfjvekfvewkljfbvkejfvbkefbvkewfv%')In the above query, I have more than 128 characters to search in like predicate, what should be in this case ? and the error message is The identifier that starts with is too long. Maximum length is 128.
Strange: I tried your query with SQL Server 2000 and that did not produce an error message. By the way, Employees.FirstName is a nvarchar(10), hence the long search term is not very useful here anyway. What do you actually want to do? Do you want to get a list of employees whose FirstName contains either 'abc' or 'def'? That would be
WHERE FirstName Like N'%abc%' OR FirstName Like N'%def%'and so on.