Change databse collation on existing installation (3.10)

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.

Nombre de messages: 3
Karma: 15
Inscrit: 02/09/2013
Localisation: Sweden

Posté: Il y a 11 ans

Hi,

Is there a way to change collation on an existing NopCommerce database? By default it seems to be SQL_Latin1_General_CP1_CI_AS, but I would need to have Swedish collation to get correct sorting in lists.

Reading the forum there seems to have been such an option when installing, which I missed and a reinstall is not possible with all the customization made. If I try to change the collation directly in the SQL Server Management Console I get error:

The object 'nop_splitstring_to_table' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
ALTER DATABASE failed. The default collation of database 'db_APSBooksOld' cannot be set to Finnish_Swedish_CI_AS. (Microsoft SQL Server, Error: 5075)

Is there some way to change collation of an existing NopCommerce installation?

Thanks,
Daniel

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.

Vous avez encore des questions ou avez besoin d'aide?

. Services d'assistance premium . Bénéficiez d'un support dédié de la part de l'équipe nopCommerce avec une réponse garantie dans les 24 heures.

. Cours en ligne pour les développeurs . Obtenez les compétences pratiques et techniques dont vous avez besoin pour gérer et personnaliser les sites Web nopCommerce.