List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:January 6 2010 6:45pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
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

Thread
Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
      • Re: Another Inserting Multiple Values with Set ProblemCarsten Pedersen6 Jan
        • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
          • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
            • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
              • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
                • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan