Skip to content

set-a-session-language.md

Latest commit

 

History

History
52 lines (40 loc) · 3.38 KB

set-a-session-language.md

File metadata and controls

52 lines (40 loc) · 3.38 KB
title Set a Session Language | Microsoft Docs
ms.custom
ms.date 03/16/2017
ms.prod sql
ms.reviewer
ms.technology
ms.topic conceptual
helpviewer_keywords
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
ms.assetid de7f2c90-8f4f-4cfc-94cc-4933a7fd2bde
author stevestein
ms.author sstein
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Set a Session Language

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] 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.