Hello.
On Sun, Jun 03, 2001 at 11:27:46PM +0200, [EMAIL PROTECTED] wrote:
> >Description:
> If a SET coumn contains values with , (comma), it's impossible to
> distinguish values with a , from multiple values.
Yes, this is the documented behaviour:
---------- http://www.mysql.com/doc/S/E/SET.html ----------
A SET is a string object that can have zero or more values, each of
which must be chosen from a list of allowed values specified when the
table is created. SET column values that consist of multiple set
members are specified with members separated by commas (`,'). A
consequence of this is that SET member values cannot themselves
contain commas.
[...]
-----------------------------------------------------------
> >Fix:
> A fix might be to escape the , in the ID == 001 case, like when returning:
> 'BLONDE\,TALL', because that also was, what the column was set to.
Regardless, this is an interesting proposal which should be
considered. Only problem is, that it would break old programs which
rely on using insertions like like "BLONDE,TALL" currently.
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
