Dear Oleg,

     i made the small modification, now it is checking only StringCol
     and replaces to UnicodeCol

     but then i receive this error when i use get() this table
     contains a TEXT field:
     
Traceback (most recent call last):
  File "D:\alco\python\admin\timeshit.py", line 44, in ?
    sa = ts_task.get(34)
  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\FormEncode-0.4-py2.4.egg\formencode\compound.py",
 line 57, in to_python
    to_python)
  File 
"c:\python24\lib\site-packages\FormEncode-0.4-py2.4.egg\formencode\compound.py",
 line 111, in attempt_convert
    value = validate(validator, value, state)
  File 
"c:\python24\lib\site-packages\FormEncode-0.4-py2.4.egg\formencode\compound.py",
 line 15, in to_python
    return validator.to_python(value, state)
  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'\xe9' in position 
37: ordinal not in range(128)

  that's why i include BlobCol as well.

  what do you think?
  
Wednesday, June 14, 2006, 4:40:21 PM, you wrote:

OB> On Wed, Jun 14, 2006 at 04:23:58PM +0200, Ivan Horvath wrote:
>>      yes, but i didn't find anything in postgresconnection which
>>      handle unicode blob fields.

OB>    Postgres has BYTEA - special byte array type for BLOBs; no need to guess
OB> if it is TEXT or BLOB.

>>      i thought also that this cannot handle binary data.
>>      should be created another column BlobUnicodeCol, or what is your
>>      idea?

OB>    I think unicode can be decoded in BLOBValidator.

OB> Oleg.



-- 
Best regards,
 Ivan Horvath
 Chief Programmer

 Alcatel ISD
 PMS 2000 Product Team

 H-1116, Budapest
 Kondorfa u. 10.
 Tel.: +36 1 209 9546
 Fax.: +36 1 209 9599
 Mobil: +36 30 257 0235
 VOIP: +49 511 676 478010
 mailto:[EMAIL PROTECTED]

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