Skip to main content
  • EN


Hello, 
I am using FME Form 2025 and looking to write  shapefiles/ geodbs dynamically to an ArcSDE Geodb.
My issue is that  where my source data has the data type VARCHAR2 it is written into Oracle as NVARCHAR2.
According to our database manager our preference is VARCHAR2 due to: “VARCHAR stores each character using a single byte, NVARCHAR columns typically consume twice as much storage space as equivalent VARCHAR columns.”

I have tried multiple options of resetting the data types and writing out either using automatic attribute definition or dynamic (using the readers schema), but in any case the final table stores NVARCHAR2.

Is it possible to change the data type from within FME?

Many Thanks!

If you use the schema feature to do the dynamic writing, it’s possible to modify the attribute type definition. I have no Oracle db so I can’t try and tell you which type you need to get this fixed, but this is what I would try.

As ​@nielsgerrits mentioned, it’s possible to modify the attribute’s data type definition for the schema feature for dynamic writing. This knowledge base article provides a tutorial on how to do so:
https://support.safe.com/hc/en-us/articles/25407525774221-Dynamic-Workflows-Advanced-Example-Modifying-the-Schema-Feature

 

Thank you, 
I tried above it still writes NVARCHAR in either case.
But I think the solution lies in the database settings. We have configuration keyword set for SDO_GEOMETRY. Setting the UNICODE_STRING parameter to FALSE should resolve the text field issue. I will report back once our DB admin is able to make the change and I can test it.

 

Community Stats

31,852
Posts
120,987
Replies
39,485
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.