On 27/11/2007, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Tue, Nov 27, 2007 at 05:54:41PM +0100, Markus Gritsch wrote:
> > Since it is allowed to use unicode and strings in a query, why is
> > there a need to force unicode?
>
>    There were reports that MySQLdb 1.2.1+ requires unicode, not merely
> allows it.

I cannot confirm this.  I use MySQL_python-1.2.2-py2.5-win32.egg and
the following example works fine.


from sqlobject import *

sqlhub.threadConnection = connectionForURI(
    'mysql://[EMAIL 
PROTECTED]/test?use_unicode=1&charset=utf8&sqlobject_encoding=utf-8')

class Person(SQLObject):
    uname = UnicodeCol()
    sname = StringCol()

Person.dropTable(ifExists=True)
Person.createTable()
p = Person(uname='\x61', sname='\x61') # '\x61' is 'a'

result = Person.select()[0]
assert result.uname == '\x61' # ok
assert result.sname == '\x61' # ok
print result.uname, result.sname # -> a a

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to