Subject Re: fail when checking VarChar variable <> ''
Author Rick Roen
Problem solved by adding Character Set ISO8859_1 to the variable
declaration.

I checked the database and found it had "NONE". Probably I had done a
restore without specifing the char set.

Thanks for your advise.

Rick

> Don't confuse character set and collation. And don't put quotes
> around the character set identifier.
>
> ./heLen
>