Subject | Re: fail when checking VarChar variable <> '' |
---|---|
Author | Rick Roen |
Post date | 2006-12-08T19:13:21Z |
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
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
>