Post reply

case sensitive collation settings

  • May 14, 2009 at 8:51 am

    #75467

    Hi all

    Just been looking though db server inventory, I have noticed that Case sensitive collation is currently being used, i want to move this to case insensitive, but was wondering, what would be the consequences of moving and are there any advantages to using case sensitive collation in the first place.

    How does this also affect SQL 2005 migration ?

    Thanks

  • May 14, 2009 at 8:56 am

    #994600

    If it is just standard case sensitive collation nothing but if your collation is case sensitive because it is BIN(binary collation) which is case sensitive by default then you could get reduced performance because most accounting third party applications use BIN for performance reason because it is the fastest sort.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply