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

Reply via email to