collation in view - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

collation in view

Author

Topic

miri
Starting Member

9 Posts

Posted - 2008-02-26 : 05:32:14

Hi,

I write a view with select statement .
I run the view from another database and I want that the view will have the same collation of the other database.
How do I write it?
I tried to write collation... in the select statement and I got error.

What can I do?

Thanks,
miri

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-26 : 05:35:45

How did you wrote the collation in the view? Post it here.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

miri
Starting Member

9 Posts

Posted - 2008-02-26 : 05:47:03

The statement is :
CREATE VIEW dbo.ZIUD
AS
SELECT ItmsGrpCod collation Hebrew_CI_AI AS ZI_SUG
FROM dbo.OITM
and I get error : "incorrect syntex near hebrew...."

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-26 : 05:54:07

quote:
Originally posted by miri

The statement is :
CREATE VIEW dbo.ZIUD
AS
SELECT ItmsGrpCod COLLATE Hebrew_CI_AI AS ZI_SUG
FROM dbo.OITM
and I get error : "incorrect syntex near hebrew...."

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources