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 <[EMAIL PROTECTED]> wrote: > James, > > Hey thanks for this, i appreciate it a lot. > > shawn > > > > On Mon, Mar 17, 2008 at 11:26 PM, James Henstridge <[EMAIL PROTECTED]> wrote: > > > > On 18/03/2008, shawn bright <[EMAIL PROTECTED]> 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. > > > -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
