Finding item query

[mrpsycho]

*edit*

final more strutured version of this post in here - http://forum.ragezone.com/f459/sql-q...n-item-648247/


i have looked for it but there was no really released working query.

i have found a thread which had a link to this thread - http://forum.ragezone.com/f459/find-...heater-562904/

the query in that thread was

select C.characteridx from cabal_equipment_table E with(nolock) inner join cabal_character_table C with(nolock) on E.characteridx = C.characteridx where master.sys.fn_varbintohexstr(E.data) like '%00003503%' and C.reputation < 320000

from my small knowledge of sql query i think i edited it correctly into

select C.characteridx
from cabal_Inventory_table I with(nolock) inner
join cabal_character_table C with(nolock) on I.characteridx = C.characteridx
where master.dbo.fn_varbintohexstr (I.data) like '%00003503%'

but it keeps giving me this error - "Server: Msg 446, Level 16, State 8, Line 1
Cannot resolve collation conflict for like operation."

i have googled around, and actualy managed once to stop giving me that error only to give another one.

if possible id like asking for comunity help making this query, mainly to find for example everyone who possessed a map part for example..

p.s i use sql2000

[MentaL]

[chumpywumpy]

The query runs fine for me on sql2000. The exact query i tested is below:

select C.characteridx, C.Name
from cabal_Inventory_table I with(nolock) inner
join cabal_character_table C with(nolock) on I.characteridx = C.characteridx
where master.dbo.fn_varbintohexstr (I.data) like '%4202%'

[mrpsycho]

when i try the query you posted above i get the folowing

Server: Msg 446, Level 16, State 8, Line 1
Cannot resolve collation conflict for like operation.

it rly cracks my skull, i have looked everywhere for a solution and i cant figure it out :(

from the stuff i read it would sugest the tables on the query have diferent collation values, but they should in theory be the same as yours, and yet you have no error when you execute the query.

i cant figure out whats wrong u_u

[chumpywumpy]

Strange. Do you have SQL service pack 4?

All of the tables are in the same db so they must have the same collation (you could check under the table properties just to be sure). It says the problem is in the "like" operation though which makes me think it's that erroring. The SQL2000 i tested on was WinXP English, what language is your OS?

[mrpsycho]

portuguese, are you in rz irc? cus if you are i can enter there to avoid spaming the forum.

*edit*

final more strutured version of this post in here - http://forum.ragezone.com/f459/sql-q...n-item-648247/