[storm] problem with unicode found as string

[James Henstridge]

On 19/03/2008, shawn bright <nephish at gmail.com> wrote:
> James,
>  I have UTF-8 Unicode as my Character Set, and all of the options for
>  collation end with _ci ( which from an online article means case
>  insensitive ) There are no options for anything ending in _cs. The
>  only other option is utf8_bin, when i select that one. i get the same
>  storm errors all over the place about expecting unicode and got type
>  string.
>  I am using the package maintainers version of the latest stable
>  mysql-server in Ubuntu, do you know what option i have to select
>  for storm to see this varchar column as a Unicode() or should i go
>  with a different data type.?

In the second URL I included, it said that the collation order is
stored in the table itself.  It seems that changing the database
collation only affects creation of new tables.  Did you try issuing
"ALTER TABLE" commands similar to what was in that document to fix
your existing tables?

James.