[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