Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Changing collation of existing view

Posted on 2008-06-25
3
Medium Priority
?
1,384 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 2000 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

Industry Leaders: 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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

670 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