[fdo-users] RE: RE: Unicode (nvarchar) support for MS SQL Server

[Brad Nesom]

What I did was to set the unicode_string=false in my sde dbtune parameter
file. I had to add this parameter to my external file under the keyword that
I use for loading my sde data and then use the "sdedbtune -o import -f
c:\myfolder\mydbtunefilename.sde -u myusername -p mypassword" command. This
is the process I had to use because the default for arcsde datatype is now
defaulted to Unicode_string=true.

I assume you are using the autodesk fdo schema products to create your
schema. You will probably have to log a support incident with autodesk on
the product you used to create the schema in mssql (map 3d?). It may be a
matter of modidfying the schema and then reloading the data. Everything I
can find mentions that changing the schema is most likely going to break the
metadata link. In other words the data and the metadata will be out of sync.
Perhaps explaining/describing what tools you used to create the schema and
load the data would help.
The autodesk support site is down for maint this morning so I am not getting
much help from that. I did find the following... it may be a useful contact
for you.
http://discussion.autodesk.com/thread.jspa?threadID=523657
Brad


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Maksim Sestic
Sent: Saturday, September 15, 2007 5:08 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] RE: RE: Unicode (nvarchar) support for MS SQL Server


I also run Google search on that topic and got equal results. Alas, I have
no
idea how to implement proposed unicode_string database property change :-)
Is this a property being set during database creation, or it's possible to
apply it somehow upon existing dataset? 

Here are some sources explaining what database property to set, but they
don't say _how_ to do it:
-
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Language_suppo
rt_in_the_geodatabase&anchor=nlsss
-
http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=About_data_typ
es

But that's almost all on that. Brad, do you also need to set that property
within Oracle datastore to be able to keep unicode strings in it?

Regards,
Maksim Sestic




bradgisoklah wrote:
> 
> I just did this on google and there may be something there to help you. I
> am an oracle user so don't know much about mssqlsrv.
> Brad
> 

-- 
View this message in context:
http://www.nabble.com/Unicode-%28nvarchar%29-support-for-MS-SQL-Server-tf442
2980s18162.html#a12689020
Sent from the fdo-users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users