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)

enter image description here

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: unicode result


Comments

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

java - Android – MapFragment overlay button shadow, just like MyLocation button -