@@ -0,0 +1,754 @@
+#!/usr/bin/python%0A%0Afrom py.test import raises%0A%0Afrom sqlobject import *%0A%0Asqlhub.processConnection = connectionForURI('mysql://nz:newzed@localhost/nz')%0A%0Afrom sqlobject.tests.dbtest import *%0A%0Aclass MyTable(SQLObject):%0A    strc = StringCol()%0A    unic = UnicodeCol()%0A    bloc = BLOBCol()    %0A    %0A%0A%0Adef test_unicode():%0A%0A    #MyTable.dropTable(ifExists=True)%0A    MyTable.createTable(ifNotExists=True)%0A    %0A    #test plain text%0A    MyTable(strc=%22plain%22, unic=%22text%22, bloc=%22col%22)%0A%0A    #test unicode objects that are plain text%0A    MyTable(strc=u%22plain%22, unic=u%22text%22, bloc=%22col%22)    %0A%0A    #test string that contain non-plain-text%0A    #note: unicode column should be in unicode.%0A    #blob column should be text.  %0A    MyTable(strc=%22%22, unic=u%22%5Cx82%22, bloc=%22%5Cx82%22)%0A%0A

test for mysql unicode and blobs