On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman <mdyk...@gmail.com> wrote:
> How about you show us the schema for the table so we know what is > defined as what? > Done in last email. > > Also, as the update does succeed, it would be interesting to see what > value actually got stored. After you have accounted for each bit in > the stored value, we might have a clue about what is being truncated. > mysql> select sizes, colorsShadesNumbersShort from products; +-------------+--------------------------+ | sizes | colorsShadesNumbersShort | +-------------+--------------------------+ | Extra-small | blue:333399 | | Extra-small | aqua:7FFFD4 | | Extra-small | blue:333399 | | | | +-------------+--------------------------+ 4 rows in set (0.00 sec) Ain't nothin' getting stored. > > One thing I did just note: the hyphen in 'Extra-Small'. Set > identifiers need to be valid mysql identifiers and the hyphen '-' is > not a valid identifier character (as it is an arithmatic operator). I > can't imagine that those colons in the colour list are healthy either. > They all work except in a certain case where I had to pull the hyphen out. I can enter all of these products individually. > > The point of a set identifier to be an easy mnemonic for a particular > bit value. Nothing is gained by trying to represent data with the > identifier itself. > Huh? Please explain. V