Das deutsche Python-Forum

Code: Alles auswählen

Traceback (most recent call last):
  File "dbsync.py", line 1024, in <module>
    init_mmv()
  File "dbsync.py", line 978, in init_mmv
    add_rows(d)
  File "dbsync.py", line 906, in add_rows
    e.save()
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/base.py", line 460, in save
    self.save_base(using=using, force_insert=force_insert, force_update=force_update)
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/base.py", line 553, in save_base
    result = manager._insert(values, return_id=update_pk, using=using)
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/manager.py", line 195, in _insert
    return insert_query(self.model, values, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/query.py", line 1436, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/sql/compiler.py", line 791, in execute_sql
    cursor = super(SQLInsertCompiler, self).execute_sql(None)
  File "/usr/local/lib/python2.6/dist-packages/django/db/models/sql/compiler.py", line 735, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python2.6/dist-packages/django/db/backends/util.py", line 34, in execute
    return self.cursor.execute(sql, params)
  File "/usr/local/lib/python2.6/dist-packages/django/db/backends/sqlite3/base.py", line 234, in execute
    return Database.Cursor.execute(self, query, params)
django.db.utils.DatabaseError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.

Code: Alles auswählen

def fixunicodes(txt):
  if type(txt) is not str:
    return txt
  
  replace = {"\xf6": "ö",
             "\xd6": "Ö",
             "\xe4": "ä",
             "\xc4": "Ä",
             "\xfc": "ü",
             "\xdc": "Ü",
             "\xdf": "ß",
             "\xb0": "°",
             "\xb2": "²" }
  
  for k in replace.keys():
    txt = string.replace(txt,k,replace[k])
    
  return txt

Code: Alles auswählen

psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
...
self.connection.set_client_encoding('UTF8')