[web2py] Setting mysql collation in web2py?

Hey, I was wondering if there's any way to set the collation of the mysql tables created by web2py to utf8_bin. Thanks!

Re: [web2py] Setting mysql collation in web2py?

Thanks for the note! I've tried passing to the driver_args a Charset object (defined by the pymysql lib like so): from gluon.contrib.pymysql import charset passing into DAL DAL(,driver_args={'charset':charset.charset_by_id(83)) in the charset module this is the Charset object I'm referring t

Re: [web2py] Setting mysql collation in web2py?

I've tracked down this problem to this code in DAL create_table: if self.dbengine == 'mysql': if not hasattr(table, "_primarykey"): fields.append('PRIMARY KEY(%s)' % table._id.name) other = ' ENGINE=InnoDB CHARACTER SET utf8;' hard coding the charac

[web2py] wget and basic authentication

Ok, so this command example is in the documentation under basic authentication (http://web2py.com/book/default/chapter/08#Access- Control-and-Basic-Authentication): wget --user=[username] --password=[password] http://.../[app]/[controller]/give_me_time but this command won't work with basic

[web2py] Problem with 'unique' in DAL and validators

Hi, So regarding web2py validators: When I define my model using the unique=True constraint on a field, it adds an IS_NOT_IN_DB validator to that field. But if I try to do a validate_and_update on that field, it throws an error in the following examples: Case 1: Passing in the whole record Say I