Update fails without blank padding.

Alessandro A. Garbagnati

Are you using a CHAR or a VARCHAR data field? I remember having the same problem with a CHAR type, and then we switched to a VARCHAR.

Joe Sam Shirah adds: In the SQL standard, CHAR is a fixed length data type. In many DBMSes ( but not all), that means that for a WHERE clause to match, every character must match, including size and trailing blanks. As Alessandro indicates, defining CHAR columns to be VARCHAR is the most general answer.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.