0

To solve our problem with accented chars searching in grid views, we decided to change the underlying MS SQL Server collation.  It seems the ALTER statement below does the job. It must be run on each column. For various purposes it would be great if we could keep this code in Mendix and let the Mendix Runtime run this. Is there any way for that or we definitely need to directly run these queries on the database? ALTER TABLE [MYDB].[dbo].[mymodule$myentity] ALTER COLUMN name NVARCHAR(200) COLLATE SQL_Latin1_General_CP1_CI_AI  

asked 2022-04-21

1 answers