Member list error: Cannot resolve the collation conflict between ...

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
5/6/2012 4:36:26 AM
msnahm
Gravatar
Total Posts 13
View Posts

Member list error: Cannot resolve the collation conflict between ...

I used Mojoportal version 2.3.6.5  and 2.3.7.0 and both of them have the following error. These versions used for Persian Content CMS.

=================================================================

Server Error in '/' Application.

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1256_CI_AS" in the equal to operation.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1256_CI_AS" in the equal to operation.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

5/6/2012 9:25:25 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Member list error: Cannot resolve the collation conflict between ...

Hi,

Its because you are using a latin collation whihc is not comaptible with Persian unicode characters. mojoPortal sql install scripts do not set any charset or collation, you need to set the collation that suits your language on your database before running the setup scripts. Probably your sql server has a default of latin, you could change the server default before cresating a database or you can change it on a new db before running setup. If you waited until after runnning setup then you would probably have to change it manually on every table and column. See this article Non-English Languages and SQL Server or do some googling to learn more. If you google for the error "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1256_CI_AS" in the equal to operation." you will find lots of results that may help you.

Hope that helps,

Joe

5/7/2012 2:53:10 AM
msnahm
Gravatar
Total Posts 13
View Posts

Re: Member list error: Cannot resolve the collation conflict between ...

Thank you Joe,
The following SQL code resolved my problem:


GO
ALTER DATABASE <<your_db_name>>
SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE <<your_db_name>>
SET ONLINE

ALTER DATABASE <<your_db_name>>
COLLATE SQL_Latin1_General_CP1256_CI_AS ;
GO

 

You must sign in to post in the forums. This thread is closed to new posts.