Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Help! Help! How can I extract from two different Character Set Oracle Database ?

  1. #1
    Join Date
    Jul 2010
    Posts
    11

    Default Help! Help! How can I extract from two different Character Set Oracle Database ?

    I need extract from two different Character Set Oracle Database , and the dest Database charset is UTF-8. What can I do ?

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    HI there,

    since the extracted fields are becoming java-strings eventually, I'd say the JDBC driver probably does the conversion for you. In wich case you don't have to worry about character sets. Just read the data, write the data. Create a short test case, my guess is that it will work just fine. In case there's any trouble you might have to convert strings manually. You could do that using scripting inside kettle or SQL charset conversion functions you'd use in your selects. But as I said, my guess is that you would not need to...

    Cheers

    Slawo

  3. #3
    Join Date
    Jul 2010
    Posts
    11

    Default

    Thanks,I use the oracel function to tranform charset.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.