sql loader problem white spaces getting inserted in CHAR datatype column - Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql loader problem white spaces getting inserted in CHAR datatype column - Urgent

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    2

    sql loader problem white spaces getting inserted in CHAR datatype column - Urgent

    Hi,
    I am migrating data from sybase database.
    the datatypes in the table structure are having char datatype and the value is not inserted exactly. so blank spaces are also getting inserted.

    please let me know to overcome the problem

    Thanks in advance.

    srinivas.

  2. #2
    Join Date
    May 2001
    Posts
    55
    COLUMN_NAME char(SPECIFY THE SIZE) "rtrim(:notes)"

    THIS SHOULD WORK, FOR EXAMPLE, IF "NOTES" IS THE NAME OF THE COLUMN AND IT IS 2000 CHARACTERS LONG IN THE DATAFILE THEN,

    NOTES CHAR(2000) "RTRIM(:NOTES)"


    WILL WORK
    A farmer learns more from a bad harvest than a good one

  3. #3
    Join Date
    Jan 2003
    Posts
    2
    my problem is i have a column CHAR(6) datatype
    but the value which is getting inserted is 'DANY' but it is getting inserted 'DANYbb'(where bb is blanks) i dont want to insert blanks.

    As there are around 1300 tables which i am loading the data i am getting a problem how to migrate the tables data exactly which is not having white spaces in the CHAR datatype fields.
    Last edited by pothula1; 01-27-2003 at 02:32 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width