Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to call different language by using "select" in MS-SQL 2005

Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12
i'm going to develop bulletin board that can be compatiable with different language.
In Web, i need to call  Table & SP  content which includes korean language.
The best way is set to whole database default language as korean. but godaddy does not alllowed me to change the MS-SQL default language (since they are hosting with others)

but, i found some way that, whenever I inserted  data, i should use like
 INSERT INTO [table] VALUES (N'content')

also, when i call the data then i can use like below
SELECT [column_name_1] COllECTION Korean_Wansung_CI_AS FROM [table]

but, my question is how can i use MUTIPLE columns (or left join, inner join, etc ) in "select"

also, how to use Korean_Wansung_CI_AS by using " Update " command

Thanks in advance



Question by:ndoorsinteractive
1 Comment
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 1000 total points
ID: 36984784
you have to repeat the COLLATE keyword for each column:
SELECT [column_name_1] COLLATE Korean_Wansung_CI_AS 
, [column_name_1] COLLATE Korean_Wansung_CI_AS 
FROM [table] 

Open in new window


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question