Oracle connector option "map fixed length to variable" for MSSQL

Author: jdisko@commandalkon.com (jdisko)

Explanation of connector option: map fixed length to variable

When our customers decide to migrate from Oracle to MSSQL they experience drastic increases in database size because we don't have this switch available in MSSQL. The Oracle varchar2 fields are migrated to MSSQL char fields.

We have tried changing the packing codes from C<#> to VC<#>, but this has an effect on various areas of our application and we do not feel it would be wise for us to attempt to change these areas.

This page has no comments.