[fdo-trac] #168: Use Unicode character types in Oracle and SqlServer providers.

[FDO]

#168: Use Unicode character types in Oracle and SqlServer providers.
-----------------------------+----------------------------------------------
   Reporter:  brentrobinson  |       Owner:  brentrobinson
       Type:  enhancement    |      Status:  new          
   Priority:  major          |   Milestone:  3.3.0        
  Component:  FDO API        |     Version:  3.3.0        
   Severity:  3              |    Keywords:  nls          
External_id:                 |  
-----------------------------+----------------------------------------------
 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.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/168>
FDO <http://fdo.osgeo.org/>
Feature Data Objects