Post reply

trailing spaces not honored in a select

  • June 10, 2010 at 2:15 pm

    #1178912

    Nope, the unique constraint would be violated. Trailing spaces are not included in the index B-Tree at all as far as I'm aware.

  • June 11, 2010 at 8:56 am

    #1179241

    It is not significant, unless you have data that came from an outside source, say migrated data.

    Yep. Been there, done that. Have a closet full of tshirts.

    LTRIM(RTRIM()) is your friend.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 2 posts - 16 through 16 (of 16 total)

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