During installation, the Microsoft SQL Server installer program detects the Windows regional setting and sets the Microsoft SQL Server language setting accordingly. Use the regional setting selected by the installation program throughout the entire Microsoft SQL Server installation.
Microsoft does not recommend changing the selected regional setting unless you have to match the regional setting to the collation of another instance of Microsoft SQL Server or to the Windows regional setting of another computer. Localized versions of Microsoft SQL Server are available in French, German, Spanish, Italian, Japanese, Korean, and Simplified and Traditional Chinese.
The collation settings must match the language settings on the system. Searching for other languages that do not match the database collation setting will result in invalid search and sort results.