Browse by Tags

All Tags » collation (RSS)
14 December 2007 23:25

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...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , ,
03 November 2007 21:03

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
Filed under: ,