Skip to content

Latest commit

 

History

History
49 lines (37 loc) · 3.27 KB

set-a-session-language.md

File metadata and controls

49 lines (37 loc) · 3.27 KB
title description author ms.author ms.date ms.service ms.topic helpviewer_keywords monikerRange
Set a Session Language
Set a Session Language
WilliamDAssafMSFT
wiassaf
03/16/2017
sql
conceptual
errors [SQL Server], international considerations
globalization [SQL Server], sessions
time [SQL Server]
sessions [SQL Server], languages
international considerations [SQL Server], sessions
dates [SQL Server], session languages
global considerations [SQL Server], sessions
client-side session language
time [SQL Server], session languages
messages [SQL Server], international considerations
server-side session language
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Set a Session Language

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] The session language can be used to set how the following elements are displayed on the server, based on language and cultural preference:

  • The language that will be used for error and other system messages. [!INCLUDEssNoVersion] supports having multiple copies of all system error strings and messages in all the languages in which [!INCLUDEssNoVersion] is available. These messages can be viewed in the sys.messages catalog view. When you install a localized version of [!INCLUDEssNoVersion], these system messages are translated for the language version that you install. By default, you also obtain the U.S. English set of these messages. Additionally, you can add user-defined messages in a specific language by using sp_addmessage.

  • The format of date and time data.

  • The names of days and months, including abbreviations.

  • The first day of the week.

  • Currency data.

There are 33 languages available for use as session settings. For a list of languages, see sys.syslanguages.

Setting the Session Language from the Server

To set the session language from the server side, use SET LANGUAGE.

Setting the Session Language from the Client

The session language can be set on the client side by using OLE DB, ODBC or ADO.NET. For OLE DB, use the SSPROP_INIT_CURRENTLANGUAGE property. For more information, see Initialization and Authorization Properties.

For ODBC, use the Language keyword. For more information, see SQLConfigDataSource.

For ADO.NET, use the Current Language parameter of the ConnectionString object. For more information, see the [!INCLUDEmsCoName] Data Access Components (MDAC) software development kit (SDK) documentation.