Collation settings for SQL 2008

[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.

[dmitri]

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.

[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!!