Skip to main content
Question

Difference in Oracle non-spatial reader and a joiner

  • December 19, 2012
  • 2 replies
  • 33 views
T
Forum|alt.badge.img
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
    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    sigtill
    Supporter
    Forum|alt.badge.img+25
    • sigtillSupporter
    • Supporter
    • December 19, 2012
    Some fixes done related to Oracle and Joiners in 2013 atleast:

     

     

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

     

     

     

    The real SigTill
    fmelizard
    Safer
    Forum|alt.badge.img+21
    • fmelizardSafer
    • Safer
    • December 20, 2012
    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

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.