support asian character and connect limit


  • Do MS SQL Express support Asian character set?

    If I want to input Traditional Chinese character, what collation I should use?


    Is there any limitation on the no of connect to MS SQL Express?

    Wednesday, March 15, 2006 4:55 AM


  • 1. Yes, MS SQL Express supports Asian character sets. Japanese, Chinese Traditional, Chinese Simplified, and Korean.

    2. A SQL collation is selected by default for English-language locales. The default collation for non-English locales is the Microsoft Windows locale setting for your computer — the Language for non-Unicode programs setting, or the closest equivalent from Regional and Language Options in Control Panel.

    The check boxes under Collation designator and sort order let you specify the sort order to use with the Collation designator you have selected. Binary is the fastest sorting order and is case-sensitive. If Binary is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available. For more information, see Windows Collation Sorting Styles in SQL Server 2005 Books Online.

    Note Change the default settings for the sort order only if your installation of SQL Server must match the collation settings used by another instance of SQL Server, or if it must match the Windows locale of another computer.

    SQL collations

    The SQL collations option is used for compatibility with earlier versions of SQL Server. Select this option to match settings compatible with SQL Server 8.0, 7.0, or earlier. For more information, see Using SQL Collations in SQL Server 2005 Books Online.

            3.  We don’t put an limit on the number of connections that can be made to SQL Express, only on resources used by SQL Express. Those limits are:   

    1 CPU

    1 Gig of RAM

    4 GB database size (each database)

    Friday, March 17, 2006 12:37 AM