Collation settings for SQL 2008

Discussion in 'Databases' started by worldcupboy, Jun 9, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. worldcupboy

    worldcupboy

    ALTER DATABASE [DBNAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    GO
    ALTER DATABASE [DBNAME] COLLATE Korean_Wansung_CI_AI;
    GO
    ALTER DATABASE [DBNAME] SET MULTI_USER;
    GO
    SELECT name, collation_name FROM sys.databases;
    GO

    We use the default collation = Korean_Wansung_CI_AI.
    but It's not working. all the korean characters are broken in SQL TABLE.

    Please help.
     
    worldcupboy, Jun 9, 2010
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    It is not necessarily broken. There can be number of reason for this problem. For example, the code page of your client is different. Please try to query your tables with MyLittleAdmin tool and see if it makes a difference.
     
    dmitri, Jun 9, 2010
    #2
  3. worldcupboy

    worldcupboy

    Yes, I can insert the korean characters using SQL Query.(No broken characters)
    I only have an issue from ASP page.

    How to match the characer set between classic ASP & MS SQL2008?

    Any comments would be appreciated!!
     
    worldcupboy, Jun 9, 2010
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page