Set SDE Data type for strings to SE_String not SE_NSTRING

Hi,

 

 

I think you should address your question to Safe support (https://safecommunity.force.com/knowledgeSubmitCase) for the definitive answer on this. I might be wrong, but I suspect FME might not be using those dataypes directly, but rather referencing the more generic "char(width)" in the API.

 

 

But could it be that you need to modify the DBTUNE table in your SDE database to prevent the default creation of unicode text fields in your database?

 

 

Look for the UNICODE_STRING setting here (http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=DBTUNE_configuration_parameter_name-configuration_string_pairs).

 

 

David

Thanks for the quick reply David.  Our preferred option is to upgarde the API rather than reconfiguring the sde database dbtune keyword.

 

 

I've submitted the question to the support desk, to see if there is a hidden quick win in configuring the writer.  but is supect you are right.

 

 

I'll post a follow up here in case anyone is interested.

Hi,

 

 

for what it's worth, I agree that upgrading the API is probably the best solution. Particularly for the long term.

 

 

David