Cannot resolve the collation conflict between

Hi
I have a new DB, in this new DB I have import and copy some data from the
old DB, among others, a report
When i try to open the report, I get this message
- Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
Any ideas.
ThanksHi
Your report's query contains JOIN on varchar/nvarchar columns which have
different collation
Try
select * from table join anothertable on table.col =anothertable.column
COLLATE danish_norwegian_ci_as
"H.Gjerde" <hg@.norspace.no> wrote in message
news:%23zJ%23Lv5PHHA.2468@.TK2MSFTNGP06.phx.gbl...
> Hi
> I have a new DB, in this new DB I have import and copy some data from the
> old DB, among others, a report
> When i try to open the report, I get this message
> - Cannot resolve the collation conflict between
> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
>
> Any ideas.
> Thanks
>|||Thank you
It help, in my plain sql script
But I stil have the problem, because I not realy sure where to put it in my
CrystalReport. The report is predefined.
...? :|
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uHN$g25PHHA.3268@.TK2MSFTNGP03.phx.gbl...
> Hi
> Your report's query contains JOIN on varchar/nvarchar columns which have
> different collation
> Try
> select * from table join anothertable on table.col =anothertable.column
> COLLATE danish_norwegian_ci_as
>
>
> "H.Gjerde" <hg@.norspace.no> wrote in message
> news:%23zJ%23Lv5PHHA.2468@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> I have a new DB, in this new DB I have import and copy some data from the
>> old DB, among others, a report
>> When i try to open the report, I get this message
>> - Cannot resolve the collation conflict between
>> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
>>
>> Any ideas.
>> Thanks
>|||Hi
I have no idea. I don't know Crystal Report
"H.Gjerde" <hg@.norspace.no> wrote in message
news:eeyQ5F6PHHA.3344@.TK2MSFTNGP02.phx.gbl...
> Thank you
> It help, in my plain sql script
> But I stil have the problem, because I not realy sure where to put it in
> my CrystalReport. The report is predefined.
> ...? :|
>
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uHN$g25PHHA.3268@.TK2MSFTNGP03.phx.gbl...
>> Hi
>> Your report's query contains JOIN on varchar/nvarchar columns which have
>> different collation
>> Try
>> select * from table join anothertable on table.col =anothertable.column
>> COLLATE danish_norwegian_ci_as
>>
>>
>> "H.Gjerde" <hg@.norspace.no> wrote in message
>> news:%23zJ%23Lv5PHHA.2468@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> I have a new DB, in this new DB I have import and copy some data from
>> the old DB, among others, a report
>> When i try to open the report, I get this message
>> - Cannot resolve the collation conflict between
>> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
>>
>> Any ideas.
>> Thanks
>>
>|||can you create SP and call it in Crystal Report
Regards
Amish shah
http://shahamishm.tripod.com
On Jan 24, 3:31 pm, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hi
> I have no idea. I don't know Crystal Report
> "H.Gjerde" <h...@.norspace.no> wrote in messagenews:eeyQ5F6PHHA.3344@.TK2MSFTNGP02.phx.gbl...
>
> > Thank you
> > It help, in my plain sql script
> > But I stil have the problem, because I not realy sure where to put it in
> > my CrystalReport. The report is predefined.
> > ...? :|
> > "Uri Dimant" <u...@.iscar.co.il> wrote in message
> >news:uHN$g25PHHA.3268@.TK2MSFTNGP03.phx.gbl...
> >> Hi
> >> Your report's query contains JOIN on varchar/nvarchar columns which have
> >> different collation
> >> Try
> >> select * from table join anothertable on table.col =anothertable.column
> >> COLLATE danish_norwegian_ci_as
> >> "H.Gjerde" <h...@.norspace.no> wrote in message
> >>news:%23zJ%23Lv5PHHA.2468@.TK2MSFTNGP06.phx.gbl...
> >> Hi
> >> I have a new DB, in this new DB I have import and copy some data from
> >> the old DB, among others, a report
> >> When i try to open the report, I get this message
> >> - Cannot resolve the collation conflict between
> >> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
> >> Any ideas.
> >> Thanks- Hide quoted text -- Show quoted text -|||H.Gjerde wrote:
> Hi
> I have a new DB, in this new DB I have import and copy some data from the
> old DB, among others, a report
> When i try to open the report, I get this message
> - Cannot resolve the collation conflict between
> "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
>
> Any ideas.
> Thanks
>
Hi
The new database you have created, seems to be created with a different
collation than the old one. If you can't change the SQL code behind the
report, your best option might be to drop the new database, create a new
one with the correct collation and then import the data again.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||you might find that it is in fact the tempdb has a different collation
than the user database. You might have to rebuild the system databases
using "rebuildm".
On Jan 24, 11:30 am, "Steen Schl=FCter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> H.Gjerde wrote:
> > Hi
> > I have a new DB, in this new DB I have import and copy some data from t=he
> > old DB, among others, a report
> > When i try to open the report, I get this message
> > - Cannot resolve the collation conflict between
> > "SQL_Latin1_General_CP1_CI_AS" and "danish_norwegian_ci_as" in the equal
> > Any ideas.
> > ThanksHi
> The new database you have created, seems to be created with a different
> collation than the old one. If you can't change the SQL code behind the
> report, your best option might be to drop the new database, create a new
> one with the correct collation and then import the data again.
> --
> Regards
> Steen Schl=FCter Persson
> Database Administrator / System Administrator