I'm having trouble with my Sql Server collation settings.
I need to access my tables in case insensitive mode (sysobjects, SYSOBJECTS, SySoBjEcTs), however the sort of my selects needs to be in an binary order.
I need this for compatibility with reports generated in other database (as Oracle, Sybase, Sybase Anywhere and Informix).
Does anyone know how can I do that?
Using binary sort, the access to the tables turn case sensitive and I have troubles with some few functions.