> 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)!?!

'' is an empty string, so it is expected that you don't get anything back with that query. If you would be getting something back, that would mean that the column did not have an empty string stored.
--
GMX DSL Doppel-Flat ab 19,99 €/mtl.! Jetzt auch mit
gratis Notebook-Flat! http://portal.gmx.net/de/go/dsl