Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Postgre: String to character

  1. #1
    Join Date
    Apr 2009
    Posts
    26

    Default Postgre: String to character

    Hello,

    I have defined a field in database:
    Code:
    isdefault character(1) NOT NULL
    I read a value (TRUE || FALSE) from a csv file.

    I'm trying to insert this value into the table but it takes as a String:
    Error inserting/updating row
    ERROR: value too long for type character(1)


    Any suggestion?

    Thanks in advance.

    Regards,
    Mikel.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Use a step like "Value Mapper" to convert your long strings to short strings (1 length). For example, TRUE --> Y and FALSE --> N or 1/0, T/F, etc.

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.