Solved

Changing collation of existing view

Posted on 2008-06-25
3
1,382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 Backup & Restore 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.

734 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