[storm] problem with unicode found as string

[shawn bright]

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.?

thanks for any help.

shawn

On Tue, Mar 18, 2008 at 8:45 AM, shawn bright <nephish at gmail.com> wrote:
> James,
>
>  Hey thanks for this, i appreciate it a lot.
>
>  shawn
>
>
>
>  On Mon, Mar 17, 2008 at 11:26 PM, James Henstridge <james at jamesh.id.au> wrote:
>  >
>  > On 18/03/2008, shawn bright <nephish at gmail.com> wrote:
>  >  > Hey there all
>  >  >
>  >  >  i keep ending up with this same problem with storm.
>  >  >  Today i have another clue.
>  >  >
>  >  >  Our software needs to be case sensitive, we recently changed hardware
>  >  >  servers and i noticed that a Varchar table with a Unicode character
>  >  >  set was not
>  >  >  seeing the difference between 'w' and 'W'. The way i solved this on
>  >  >  the older server was to set the binary flag in the mysql column. As
>  >  >  soon as i did, i was getting storm errors everywhere about expecting
>  >  >  type Unicode and getting type string.
>  >  >
>  >  >  I am running MySql version 5.0.45-1ubuntu
>  >  >  python-mysqldb version 1.2.2-3-1ubuntu
>  >  >
>  >  >  ( not sure what the 1ubuntu means, just part of the numbering system
>  >  >  of my preferred linux flavor, i suppose.)
>  >
>  >  This sounds like you're seeing locale specific collation rules.
>  >  Perhaps the following pages might help:
>  >
>  >     http://dev.mysql.com/doc/refman/5.0/en/charset-configuration.html
>  >     http://is2.xspaces.org/2004/11/28/mysql-and-utf8
>  >
>  >  If you set the collation rule to a case sensitive one, then you should
>  >  see the results you expect.
>  >
>  >  James.
>  >
>