sql what is collate code example

Example: sql COLLATE

-- set language
USE master;
GO
ALTER DATABASE [M9_SAS_5.1.6_liquid]
COLLATE French_CI_AS ;
GO
 
-- Verify the collation setting.
SELECT name, collation_name
FROM sys.databases
WHERE name = N'DB_name';
GO

-- you can also need to change your user's property
ALTER LOGIN <SEU_LOGIN> WITH DEFAULT_LANGUAGE = Français