Subject | Value '' in varchar column |
---|---|
Author | crizoo4712 |
Post date | 2010-10-28T07:29:29Z |
Hi all,
what is the value stored in a varchar() column by:
update tab1 set col1 = '' ?
It can be selected the same way (select * from tab1 where col1 = ''
But..
..select cast(col1 as varchar(128) character set octets) from tab1
..doesn't show anything (even not <NULL> or hex low value)!?!
Regards, Christoph
what is the value stored in a varchar() column by:
update tab1 set col1 = '' ?
It can be selected the same way (select * from tab1 where col1 = ''
But..
..select cast(col1 as varchar(128) character set octets) from tab1
..doesn't show anything (even not <NULL> or hex low value)!?!
Regards, Christoph