Article ID: 196771 - Last Review: March 14, 2006 - Revision: 2.1 FIX: @@language Value Can Be Truncated After Changing ValueThis article was previously published under Q196771
BUG #: 53101 (SQLBUG_70)
SYMPTOMS
If SET LANGUAGE is used to change a client's current language setting or
@@LANGUAGE to a language with a shorter name and then back to the original
language, @@LANGUAGE is truncated to the length of the shorter language
name plus one byte.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 232570
(http://support.microsoft.com/kb/232570/
)
INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.
MORE INFORMATION
If a client changes from "us_english" to "german" and back to "us_english",
@@LANGUAGE contains "us_engl" rather than "us_english".
| Article Translations
|
Back to the top
