Solved

Changing collation of existing view

Posted on 2008-06-25
3
1,381 Views
Last Modified: 2008-06-26
Hi folks,
Is it possible to change the collation propert of an existing view? If yes, could you please describe how.
0
Comment
Question by:innocent1973
  • 2
3 Comments
 
LVL 12

Expert Comment

by:patrikt
ID: 21864538
What is Collation of View? Do you mean collation of some column in result or order collation?
For changing collation you can use '<column> COLLATE <collation name> '. It will convert column output to desired collation.

Patrik
0
 

Author Comment

by:innocent1973
ID: 21864794
is it possible to convert all columns in once?
0
 
LVL 12

Accepted Solution

by:
patrikt earned 500 total points
ID: 21864914
No, COLLATE  is like a function so acts only on preceding expression.
But why do you need to convert all? Your table is wrong or other problem? May be there is simplier solution.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Review MS SQL cluster diagram 9 101
sql help 5 54
SQL Express connecting form remote error 26 7 52
Passing value to a stored procedure 8 107
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 we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

820 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