Information générale
Forum:
Microsoft SQL Server
>Has anyone had problems with Sorts not properly working with mysql if there is any null values within a field. If so, how do you fix it? Ex: lower case will be mixed in among upper case text. This should not happen based on the ascii values. Any suggestions would be greatly appreciated.
>
>Sue
Hmm... with SQL Server it depends on your collation setting of the table. Have you tried to ORDER BY upper(fieldname) ?
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement