locked
I want To Create Table And All Column Name Will be bangali langauge RRS feed

  • Question

  • My Data Is bangali langauge For This  I Want To Create A Database .So How Can Setup SQl Server For Use Bangali langauge .  
    Tuesday, November 17, 2015 6:40 PM

Answers

  • To change SQL Server language, open SQL Server Management Studio (SSMS) > Right click Server in Object Explorer > Properties > Advanced > Check the ‘Default Language’ property and make sure it is set to the one you want.

    Using TSQL:

    Look up the sys.messages catalog view to check if SQL Server supports a message in your local language.

    SELECT msg.language_id, lang.langid, alias 
    FROM
    sys.messages AS msg
    JOIN
    syslanguages AS lang
    ON lang.msglangid = msg.language_id
    GROUP BY  msg.language_id, lang.langid, alias

    then once you know the langid use below tsql

    EXEC sp_configure "default language", n  -- n = `langid` that you want to set
    RECONFIGURE WITH OVERRIDE;

    note: you have to restart SQL server and this is an instance wide setting.


    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:45 AM
    Tuesday, November 17, 2015 8:06 PM
  • My Data Is bangali langauge For This  I Want To Create A Database .So How Can Setup SQl Server For Use Bangali langauge .  

      hier have all about using "Bangla" in ms sql server

    bangla lang in sql server

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:44 AM
    Tuesday, November 17, 2015 7:03 PM

All replies

  • My Data Is bangali langauge For This  I Want To Create A Database .So How Can Setup SQl Server For Use Bangali langauge .  

      hier have all about using "Bangla" in ms sql server

    bangla lang in sql server

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:44 AM
    Tuesday, November 17, 2015 7:03 PM
  • To change SQL Server language, open SQL Server Management Studio (SSMS) > Right click Server in Object Explorer > Properties > Advanced > Check the ‘Default Language’ property and make sure it is set to the one you want.

    Using TSQL:

    Look up the sys.messages catalog view to check if SQL Server supports a message in your local language.

    SELECT msg.language_id, lang.langid, alias 
    FROM
    sys.messages AS msg
    JOIN
    syslanguages AS lang
    ON lang.msglangid = msg.language_id
    GROUP BY  msg.language_id, lang.langid, alias

    then once you know the langid use below tsql

    EXEC sp_configure "default language", n  -- n = `langid` that you want to set
    RECONFIGURE WITH OVERRIDE;

    note: you have to restart SQL server and this is an instance wide setting.


    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:45 AM
    Tuesday, November 17, 2015 8:06 PM