Use Unicode character types in Oracle and SqlServer providers.

[brentrobinson]

Under this enhancement, the Oracle and SqlServer providers would be changed to create columns for string properties as nvarchar(2) instead of the current varchar(2). These types provide more flexibility for users of non-ASCII7 character sets:

• for the FdoIInsert command, eliminates cases where a string to insert expands to be too big for the column, when converted from wide-char to the database character set.
• for SqlServer, eliminates the need to make sure that the database and user's character sets match.

The above applies only to new properties created in FDO datastores. Pre-existing columns in FDO datastores will remain as varchar(2). Types for columns in non-FDO datastores will not change.

The main changes are to fdo_sys.sql.

[brentrobinson]

Revision: 3543 Author: brentrobinson Date: 1:42:39 PM, Wednesday, November 07, 2007 Message: Ticket#168: Create string columns in Oracle and SqlServer datatores as nvarchar(2).

---

Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/FdoApplySchemaTest.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.cpp Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/Common/SchemaMgrTests.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/LogicalPhysicalBender.xslt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_err3S_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_test1_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_test2_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_test3_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_test4_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/apply_schema_test5_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_Oracle_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_SqlServer2005_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/gen_default1_SqlServer_master.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/schema_rb_nnyn_master.txt Modified : /trunk/Providers/GenericRdbms/com/fdo_sys.sql