Subject | Collate |
---|---|
Author | paulo@tgr.com.br |
Post date | 2004-04-29T21:32:40Z |
I'm using 'ORDER BY COLUMN1 COLLATE PT_PT' to achieve the sorting I
expect in my language. What would be the best way to add 'COLLATE
PT_PT' to my queries and still use all the nice automagical IBO
features like title click ordering on grids? It'd be great if it
could be specified as a column property like it's already done for
case-sensitivity (TABLE.COLUMN=NOCASE)
I don't want to use COLLATE when creating tables because it uses up
vital space (triple as much) in indexes.
I'm working with TIB_Query and putting column properties in
TIB_Connection.
Paulo
expect in my language. What would be the best way to add 'COLLATE
PT_PT' to my queries and still use all the nice automagical IBO
features like title click ordering on grids? It'd be great if it
could be specified as a column property like it's already done for
case-sensitivity (TABLE.COLUMN=NOCASE)
I don't want to use COLLATE when creating tables because it uses up
vital space (triple as much) in indexes.
I'm working with TIB_Query and putting column properties in
TIB_Connection.
Paulo