[fdo-trac] #729: SQLServerSpatial: nvarchar columns sometimes blank padded.

FDO trac_fdo at osgeo.org
Thu Nov 25 13:39:20 EST 2010


#729: SQLServerSpatial: nvarchar columns sometimes blank padded.
---------------------------------+------------------------------------------
   Reporter:  brentrobinson      |       Owner:  brentrobinson                         
       Type:  defect             |      Status:  new                                   
   Priority:  major              |   Milestone:  3.6.0                                 
  Component:  SQLServer Spatial  |     Version:  3.6.0                                 
   Severity:  2                  |    Keywords:  SQL Server 2008 nvarchar character pad
External_id:                     |  
---------------------------------+------------------------------------------
 Steps:

 Steps:
  * in SQL Server Management studio:
   * create a new database.
   * load  the attached script
   * change the using statement to use your datastore
   * run the script to create the fc table.
  * Using the FdoInsert FDO API command, add a feature to the fc class. Set
 the name to 'feat1'.
  * Go back to SQL Server Management studio and run the following:

 {{{

     use <your datastore name>;
     select 'X' + name + 'X' from dbo.fc;
 }}}

 The name value is padded with spaces, e.g.: 'Xfeat1      X'

 name is an nvarchar so its values shouldn't get padded.

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


More information about the fdo-trac mailing list