>How to display in a grid the correct alphabetical order
>regardless of the names to be capital fonts or not ?
Let's assume you want to sort by a column that contains names.
I know two quite different methods.
1) Use an index that has the expression
upper(name). This index will sort uppercase and lowercase (mayúsculas y minúsculas) correctly. Letters with diacriticals (acentos) will still be sorted at the end, though.
2)
SET COLLATE TO GENERAL, and then create the index. UPPER() is not necessary in this case. This index will sort upper- and lowercase correctly, and also accented characters. However, the index will take up twice the normal space.
Be careful - you should not use SET COLLATE TO GENERAL in all your indices. For instance, an index on an integer PK or FK, created with bintoc(), will cause some strange results.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
