Hi,
I can't think of a standard setting anywhere that will let you do
this, so I suspect that the only method would be to change the
attr_type_map in a metafile.
eg in C:\Program Files\FME\metafile\oracle8i.fmf look for the line...
ATTR_TYPE_MAP char(width) fme_char(width) \
...and change it to...
ATTR_TYPE_MAP varchar2(width) fme_char(width) \
Or you could find the equivalent Shape metafile and change that to
create fme_varchars from Shape char fields.
In fact, now I think of it, instead of editing the line you should
probably just add a new mapping. So that part of the file would read...
ATTR_TYPE_MAP varchar2(width) fme_char(width) \
char(width) fme_char(width) \
varchar2(width) fme_varchar(width) \
...that way you aren't removing "char" as a type from the Oracle
reader, just mapping what happens when you write to Oracle.
HOWEVER - I can't emphasise enough that editing metafiles like this is
NOT recommended behaviour. Our Oracle developer will probably choke on
his coffee when he sees what I've told you to do. I make no guarantees
over what such a change would do to your data or to your FME, and I
don't even guarantee it will work. But if someone was holding me to
ransom, saying "re-map my attributes, or your cactus plant gets it"
then this is where I'd start to experiment.
Hope this helps,
Mark
PS - I mean it. You try this one at your own risk.
--- In [email protected], "mark_watts01" <[EMAIL PROTECTED]> wrote:
>
> Is there a way to change the default mappings for data types?
> For example converting a CHAR field from an shape file to oracle
> spatial results in a fixed length CHAR field in oracle. I would
> prefer CHAR to map to an Oracle Varchar2 without having to change
> each field manually.
>
For insights into what's up at Safe Software and what's on the development
horizon, visit Safe's blog at spatial-etl.blogspot.com.
Love FME? Then open your diary to March 6-7, 2008 and write this... "Second
Worldwide FME User Conference - Must Attend!" See
http://www.safe.com/company/fmeuc2008/index.php for more details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/fme/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
