HELP! problem with queries in MS CRM

Hi, there,

i have this simple question.

I have MS CRM 3.0 installed on my work PC, when i try to get result from query like this

"select * from systemuserbase where fullname like '%Ж%'

SQL server returns me notthing.

i have many rows, containing words with this charcter in this column.

i don't understand.

In other DB this query would be fine and will return rows. What i miss?

thanks.

Is this an issue with Crystal? When I run the query below I seem to get the correct row:

Code Snippet

declare @.xample table (fullName varchar(20))
insert into @.xample
select 'Jon Ж McDaniel' union all
select 'John Q Public'
--select * from @.xample

select * from @.xample
where fullName like '%Ж%'

/*
fullName
--
Jon ? McDaniel
*/

|||

No, this table is standart table created from MS CRM and i don't know what whuld happend if i change column types. This is working system and i don't want to break it. Current column type is nvarchar. In other DB wich are not connected with CRM in same server i don't have problems. I have only one diference between those DB's it is coallition. In CRM it is Latin1_General_CI_AS, and in oder is Cyrillic_General_CI_AS.

I think the problem could be there. Is there way to run querys with different coallition, adn what is the right syntax?