A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.
Mari thanks for answering.
I've been trying to change collation on the existing database. When I ALTER the DB to change collation to Finnish_Swedish_CI_AS
ALTER DATABASE episerver_intranet_svd_mogul_se COLLATE Finnish_Swedish_CI_ASit seems not to be affecting the existing data. I found a way to sort objects by altering the Name column
ALTER TABLE dbo.tblPage
ALTER COLUMN [Name] NVARCHAR(255)
COLLATE Finnish_Swedish_CI_AS and the sorting woks correctly but it deleting object raises an exception. After that I tried to set both, collation of the database and then collation of this column but still the same exception when deleting a page:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Finnish_Swedish_CI_AS" in the UNION operation. So it's obvious that changing collation on the database didn't affect everything for existing objects.
I wonder two things. Is it possible to change collation on existing database
or it must be done while installing the fresh one. And also more important
issue is if sorting feature is tied to database collation, how does multilanguage
support handles the sorting? For example if user switch to English, and collation
is Finnish_Swedish_CI_AS he would still get "non-english" sort order, right?
Hi Milos,
About your error message, we have an old faq about that problem that might be worth looking on,
http://www.episerverworld.com/FAQ/Items/Cannot-resolve-collation-conflict-for-UNION-operation/
Hi
Is there a way to have sort order alphabetically considering Swedish letters? At the moment we have SV as default language, page structure is created in Swedish but pages starting with Å, Ä or Ö get sorted as letters are A or O instead of being put at the end of the list.