sql - Like Operator does not work -
i have following code in sql server 2014 enterprise:
select c.id dbo.content c c.id = 8753495 , c.content '%paypal%'
this code used know if content has match word paypal , returning 0 results, , id, know has in content word "paypal" .
i've tried different words of content , words it's working , others doesn't.
the database content
table both use sql_latin1_general_cp1_ci_as
collation.
can me?
edit: purpose of query else, not return id, found problem on operator, give part failing
also tried upper/lower still doesn't work
here creation script.
create table [dbo].[content]( [id] [int] not null, [content] [nvarchar](max) null, constraint [pk_content_1] primary key clustered ( [id] asc )with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on, fillfactor = 100) on [primary] ) on [primary] textimage_on [primary] go
thanks replies.
edit 2: question isn't answer like operation returns no rows on nvarchar column filter if column data start numeric. there space @ end of pattern.
the problem here malicious client put characters looks similar, way avoids verifications , send spam
for example, unicode 1056 decimal (420 hexa) greek character similar latin p (ascii 80)
well, found error.
the content uploaded client (a spammer) , when ascii of each character, found out client put content on unicode characters similar.
so "paypal" wasn't "paypal" expected, here result of paypal word comparison expected result:
Comments
Post a Comment