Dear sqlobject-discuss, this is my class definition:
class ts_times(SQLObject): class sqlmeta: idName = "trans_num" fromDatabase = True in the connection string i use use_unicode=1 parameter. there is a varchar column which has StringValidator not UnicodeStringValidator object therefore a list(ts_times.select()) fails File "D:\alco\python\admin\timeshit.py", line 42, in __main__ sb = list(sa) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\sresults.py", line 156, in __iter__ return iter(list(self.lazyIter())) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\dbconnection.py", line 769, in next obj = self.select.sourceClass.get(result[0], selectResults=result[1:], connection=self.dbconn) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\main.py", line 917, in get val._init(id, connection, selectResults) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\main.py", line 959, in _init self._SO_selectInit(selectResults) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\main.py", line 1158, in _SO_selectInit colValue = col.to_python(colValue, self._SO_validatorState) File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\col.py", line 516, in to_python return value.encode("ascii") UnicodeEncodeError: 'ascii' codec can't encode character u'\xf6' in position 7: ordinal not in range(128) what is the problem? -- Best regards, Ivan Horvath Chief Programmer Anyone who has never made a mistake has never tried anything new. /Albert Einstein/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss