Post reply

Blank spaces

  • September 19, 2002 at 8:50 am

    #158949

    Hello,

    Somebody can tell me how to make so that my database doesn't record blank spaces

    in the fields of type char,

    thank you

  • September 19, 2002 at 11:15 am

    #436891

    Setup a trigger to rtrim() the fields. But for CHAR, there will always be blanks.

  • September 20, 2002 at 4:48 am

    #436958

    CHAR defines the field as fixed length. If you do not fill the columns full length spaces are generated automatically. When retriving the data you may need to perform a rtrim to get a proper compare but I have seen this few and far between and depends mostly on the language the app is programmed in doing the compare.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply