Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Varchar value conversion error

  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Default Varchar value conversion error

    I have a job which reads from a table in teradata, does lookups and inserts into another teradata table. During this process the varchar values with apostrophe's are getting converted to arrow
    Example - "there's" is converted to there(arrow)s

    Can anyone suggest what needs to be done here? Do i need to apply any specific encoding.

    This data load works fine when it is done in Teradata using a SP.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Have you already tried to double each apostrophe?
    So long, and thanks for all the fish.

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.