select query acting weird... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

select query acting weird...

Author

Topic

emmim44
Yak Posting Veteran

65 Posts

Posted - 2012-06-25 : 09:03:33

Hi all,
I am trying the below simple query but it doesnt return any rows...when I remove "is" that is Turkish character from it... it does...Somehow Turkish chars are not shown here, they are converted to english chars....beside that what is wrong with this simple query?

doesnt bring records in db even there are similar ones.
select * from org where ident_org like '%Bilgi Yönetimi - Pazarlama ve Satis%'
---
brings records
select * from org where ident_org like '%Bilgi Yönetimi - Pazarlama ve Sat%

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-06-25 : 11:15:30

what is length of column ident_org ?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2012-06-25 : 11:20:59

try adding the symbol for UNICODE - like this:

where ident_org like N'%Bilgi Yönetimi - Pazarlama ve Satis%'

EDIT:


--This works 
select *
from   (
       select nchar(257) as c
       ) d
where c like N'%a%'

--This doesn't
select *
from   (
       select nchar(257) as c
       ) d
where c like '%a%'

OUTPUT:
c
----
a

(1 row(s) affected)

c
----

(0 row(s) affected)

Be One with the Optimizer
TG

emmim44
Yak Posting Veteran

65 Posts

Posted - 2012-06-25 : 13:51:29

I think that you hit the nail on the right spot. Thank you TG.

emmim44
Yak Posting Veteran

65 Posts

Posted - 2012-06-25 : 13:52:54

quote:
Originally posted by yosiasz

what is length of column ident_org ?
128 ...but I think that TG gave the right answer. Thank you for ur time though.
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2012-06-25 : 13:53:38

You're welcome.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources