Skip to main content

informatica cloud to Vertica data load not handling special characters

  • October 9, 2014
  • 2 replies
  • 18 views
kannan_1
Forum|alt.badge.img+1
Hello,

We are moving data from SFDC to Vertica using the Informatica cloud. But the special characters are not loading correctly in Vertica. 

Any help would be highly appreciated. 

Eg - 

For Source Colum , the valus is MONTRÉAL

where as for the destination it is - MONTR��AL

    2 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • October 9, 2014
    How do you connect with Vertica using odbc or plug in. This seems to be something with the locale of the destination. 

    kannan_1
    Forum|alt.badge.img+1
    • kannan_1
    • Author
    • Participating Frequently
    • October 9, 2014
    We are using the ODBC to connect.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement