Hi, I have a table that contains a varchar and there is a unique constraint on that varchar column.
My problem is that I would need the table to allow values that differ (only) in trailing whitespace. Due to the char/varchar legacy compatibility debacle (ugh!) that dictates that varchar and char values that differ in trailing whitespace should be considered equal, this is not allowed using a regular unique constraint. Is there any better way to solve this, than using a unique computed index on the expression varcharcol || '.' or something similar? (And, are there in fact, any major drawbacks with the computed unique index solution?) Regards, Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: [email protected] Telefon: 08-761 06 55 Mobil: 0733-44 24 64
