On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman <mdykman@stripped> 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
