Encoding for test database

58 views
Skip to first unread message

Carlos Aguilar

unread,
Jan 25, 2014, 7:55:07 PM1/25/14
to django-users
I have this settings for my database connection:

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
        'NAME': 'solomon', # Or path to database file if using sqlite3.
        # The following settings are not used with sqlite3:
        'USER': 'postgres',
        'PASSWORD': '',
        'HOST': 'localhost', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
        'PORT': '', # Set to empty string for default.
        'CONN_MAX_AGE': 0,
        'TEST_CHARSET': 'UTF8',
    }
}

Running test I have this error:

======================================================================

ERROR: test_adView (api.tests.AdTestCase)

----------------------------------------------------------------------

Traceback (most recent call last):

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/test/testcases.py", line 178, in __call__

    self._pre_setup()

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/test/testcases.py", line 749, in _pre_setup

    self._fixture_setup()

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/test/testcases.py", line 881, in _fixture_setup

    'skip_validation': True,

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 159, in call_command

    return klass.execute(*args, **defaults)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/raven/contrib/django/management/__init__.py", line 37, in new_execute

    return original_func(self, *args, **kwargs)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/management/base.py", line 285, in execute

    output = self.handle(*args, **options)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", line 55, in handle

    self.loaddata(fixture_labels)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", line 84, in loaddata

    self.load_label(fixture_label)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/management/commands/loaddata.py", line 140, in load_label

    obj.save(using=self.using)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/core/serializers/base.py", line 164, in save

    models.Model.save_base(self.object, using=using, raw=True)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/base.py", line 573, in save_base

    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/base.py", line 635, in _save_table

    forced_update)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/base.py", line 679, in _do_update

    return filtered._update(values) > 0

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/query.py", line 507, in _update

    return query.get_compiler(self.db).execute_sql(None)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 975, in execute_sql

    cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 781, in execute_sql

    cursor.execute(sql, params)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute

    return self.cursor.execute(sql, params)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/utils.py", line 99, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/home/vagrant/socialdasboard/local/lib/python2.7/site-packages/django/db/backends/util.py", line 53, in execute

    return self.cursor.execute(sql, params)

DataError: Problem installing fixture '/vagrant/socialdashboard/apps/bidding/fixtures/initial_data.json': Could not load bidding.Region(pk=19653): character with byte sequence 0xc6 0x92 in encoding "UTF8" has no equivalent in encoding "LATIN1"


I am trying to load a fixature to use with geodjango.

I appreciate your help with this.

Best Regards


--
Carlos Aguilar
Consultor Hardware y Software
DWD&Solutions
http://www.dwdandsolutions.com
Reply all
Reply to author
Forward
0 new messages