C/SIDE to SQL Migration using the SQL Data Type Variant.

mdmartin

I'm in the process of migrating from C/SIDE to SQL, during testing (migrate.fob) I have received a number of code field issues that will occur when I migrate, such as the known sorting sequence difference between C/SIDE and SQL. These particular code fields hold both alphaumeric and integer values, I was considering making use of the SQL Data Type 'Variant' which is a property within each field which sorts the data into alphanumeric then integer. Does anyone know any side effects of using the Variant SQL Data Type?

Thanks

Michael

Eugene

i don't know how it is done in MSSQL but for example in Sybase one can (when creating a database) feed the server with a special collation file where you specify the order of the symbols. The database then uses the given collation for sorting and indexing text fields