Skip to main content
Question

Difference in Oracle non-spatial reader and a joiner

  • 19 December 2012
  • 2 replies
  • 6 views

Hi,

 

 

I have problem with the joiner-transformer. When joining tables from an Oracle database all unicode characters are not handled correct. Ex æøåÆØÅ.

 

 

But if I create another reader-import-type with the same table it handles the unicode characters correct.

 

 

Is there a setting on the joiner-transformer that i have missed? Or is it a bug?

 

 

(I'm using fme 2012SP4 right now but the problem was also present the previous version I used. I think it was v2010.)

 

 

/Tim
Some fixes done related to Oracle and Joiners in 2013 atleast:

 

 

http://downloads.safe.com/fme/beta/whatsnew.txt

 

 

 


Hi folks,

 

I  tested this in FME 2013 (Build 13250) and I can see the issue Tim described still there.  I would have thought the fixes SigTill pointed to would have resolved this but apparently not.  I will escalate this to a support case so we can track the issue.  

 

 

Looks like you are aware of this but for the sake of others,  if you add the table with a reader and use the FeatureMerger transformer you can get around the issue.

 

 

Thanks for reporting this Tim - it really helps us when people take the time to tell us about issues,

 

Ken

Reply