This blog will no longer be updated.

New content is available on my new blog

tips and tricks,collation - Piotr Rodak

Browse by Tags

All Tags » tips and tricks » collation (RSS)

changing collation of all columns without dropping them

Just this week I had opportunity to change collation of all objects using it in a database without dropping it. I like to computers to do what computers should do - work that is :). So I created a query that gave me script changing collation of all columns...

sorting trap

So, you might think that sorting within ASCII range is predictable and order defined by ASCII table is finite? You are on safe side when you do not use unicode nor 'fancy' letters? Well.. you are wrong. Recently I have been working on comparison of data...
Posted by Piotr Rodak | with no comments