Answers for "sql COLLATE"

SQL

1

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

Posted by: Guest on February-19-2021

Code answers related to "sql COLLATE"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#