cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
derickab72
Engaged Sweeper
I want to use both my Lansweeper and SCCM databases to build reports and cross reference the informaaiton. The SCCM databases collation is SQL_Latin1_General_CP1_CI_AS where Lansweepers is
Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
derickab72 wrote:

Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?

Yes, it will break, you will need to use a collate conversion function in your queries.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
derickab72 wrote:

Latin1_General_CI_AI. If i was to change the Lansweepers collation to match SCCM will it break the database?

Yes, it will break, you will need to use a collate conversion function in your queries.