SQL Server Alias Types

markf909 · 2008-05-25 14:19:39

So I have a user defined alias type CREATE TYPE col1 FROM nVarChar(100); Does anybody know how to define a collation for that user defined alias type? E.g CREATE TABLE dbo.Tab ( mycol col1 COLLATE SQL_Latin1_General_CP1_CS_AS NULL; ) Does not work. Using Server 2005, anybody know if this is possible?

25-05-2008 03:19PM

#1

markf909

Closed Accounts Posts: 461 ✭✭

Join Date: February 2005

Posts: 446

So I have a user defined alias type

CREATE TYPE col1 FROM nVarChar(100);

Does anybody know how to define a collation for that user defined alias type?

E.g

CREATE TABLE dbo.Tab
(
mycol col1 COLLATE SQL_Latin1_General_CP1_CS_AS NULL;
)

Does not work.

Using Server 2005, anybody know if this is possible?

0

Comments

#2 26-05-2008 03:04PM

kayos

Registered Users, Registered Users 2 Posts: 2,494 ✭✭✭

Join Date: April 1999

Posts: 2356

Dont think it can be done mate sorry. The UDT collation is taken from the database's default collation.

0
#3 27-05-2008 12:20PM

Ginger

Registered Users, Registered Users 2 Posts: 2,929 ✭✭✭

Join Date: January 2003

Posts: 2656

The UDT collation is based on the database collation where it was defined

http://msdn.microsoft.com/en-us/library/ms187630.aspx

You can use casts/converts if required..

0