SQL collation

My struggles with a customer's database that used a different collation sequence. The easy way is never the right way, or is it?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(41)

You rated this post out of 5. Change rating

2018-06-08 (first published: 2016-01-14)

4,577 reads

Blogs

Third part in my Ai series with databases. When building AI solutions within the...

This month we have a very interesting invitation from Koen Verbeeck. He has hosted...

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...

phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...

phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...

I have 13 restricted views in my EDW DB. 6 of them are created...

Does this run successfully on a SQL Server 2022, US English default installation?

DECLARE @YenAmount MONEY;
SET @YenAmount = ¥1500; 

SELECT @YenAmount AS RawValue;