Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    5

    Question Unanswered: How to store CR in a char field ?

    Hi, folks,

    it sounds quite simple but produces many efforts to avoid bad impacts : how will a carriage return character be stored in a character field without loosing ability to unload and load the table ?

    Does Informix come with any tools for it ?

    At the moment I have to mask and unmask before unload or after load which has to be done for some reasons from time to time ! Will there be any convention which masking character has to be used ?

    With regards,

    Christof.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

    If you use the function "delimiter", then I guess, you dont have to worry about carriage return character in the data:

    eg

    unload to xyz.dat delimiter "|"
    select * from tab_nm

    Bye

    Nitin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •