collate example please urgent - 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

General SQL Server Forums

New to SQL Server Programming

collate example please urgent

Author

Topic

rajadadi
Starting Member

30 Posts

Posted - 2010-05-06 : 07:14:53

tell me Collate example with syntax

rajesh

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-05-06 : 07:34:34

CREATE TABLE t1
(
a VARCHAR(10) COLLATE FINNISH_SWEDISH_CI_AS
)

N 56°04'39.26"
E 12°55'05.63"

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-06 : 07:35:38

where col1 COLLATE <your_wanted_collation_here> = col2 COLLATE <same_collation_here>

No, you're never too old to Yak'n'Roll if you're too young to die.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-05-06 : 07:37:31

...or...

CREATE 
	DATABASE [DBName] ON PRIMARY 
		(NAME = N'DBName', FILENAME = N'c:\path\DBName.mdf' , SIZE = 1GB , MAXSIZE = UNLIMITED, FILEGROWTH = 10% ),
	LOG ON 
		(NAME = N'DBName_log', FILENAME = N'd:\path\DBName.ldf' , SIZE = 50MB , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
	COLLATE Latin1_General_CI_AS
GO

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein

rajadadi
Starting Member

30 Posts

Posted - 2010-05-07 : 00:56:41

where col1 COLLATE <your_wanted_collation_here> = col2 COLLATE <same_collation_here>

can you give this syntax example

rajesh

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-05-07 : 00:59:16

quote:
Originally posted by rajadadi

where col1 COLLATE <your_wanted_collation_here> = col2 COLLATE <same_collation_here>

can you give this syntax example

rajesh

That's the example. Just replace those in BOLD with your collation.

KH
[spoiler]Time is always against us[/spoiler]

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-05-07 : 11:29:05

quote:
Originally posted by rajadadi

tell me Collate example with syntax

rajesh

"Please" would be nice!

Terry

-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby

ramar
Starting Member

2 Posts

Posted - 2012-04-25 : 08:29:30

plzzz...tell me briefley about the collas function....how i can use that with example

not for me only its for all

ramar
Starting Member

2 Posts

Posted - 2012-04-25 : 08:31:29

plz...tell me briefly about the collate function....how i can use that with example

not for me only its for all

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-04-25 : 08:42:26

quote:
Originally posted by webfred

where col1 COLLATE <your_wanted_collation_here> = col2 COLLATE <same_collation_here>

No, you're never too old to Yak'n'Roll if you're too young to die.

So the above isn't an example?
Or why do you ask for an example?

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources