unicode (again): initenv fails under postgres

[Alec Thomas]

I think I recalled seeing some post to the ML about this, but couldn't find it when I did a search.

Creating and Initializing Project
 Installing default wiki pages
 /home/athomas/projects/trac/devel/wiki-default/CamelCase => CamelCase
Failed to initialize environment. 'ascii' codec can't encode character u'\u201c' in position 237: ordinal not in range(128)
Traceback (most recent call last):
  File "/home/athomas/projects/trac/devel/trac/scripts/admin.py", line 606, in do_initenv
    self._do_wiki_load(default_dir('wiki'), cursor)
  File "/home/athomas/projects/trac/devel/trac/scripts/admin.py", line 793, in _do_wiki_load
    self._do_wiki_import(filename, page, cursor)
  File "/home/athomas/projects/trac/devel/trac/scripts/admin.py", line 763, in _do_wiki_import
    cursor, (title, int(time.time()), data, title))
  File "/home/athomas/projects/trac/devel/trac/scripts/admin.py", line 160, in db_update
    cursor.execute(sql, params)
  File "/home/athomas/projects/trac/devel/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/home/athomas/projects/trac/devel/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3043, in execute
    parms = (self.__unicodeConvert(parms[0]),)
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 2745, in __unicodeConvert
    converted_obj.append(item.encode(*self.conn.client_encoding))
UnicodeEncodeError: 'ascii' codec can't encode character u'\u201c' in position 237: ordinal not in range(128)

This was during my attempt to install Postgres for testing the tags plugin.

[Christian Boos]

Well, I don't use postgres for now, so I guess someone else has to address this one.

[Jonas Borgström]

Okay, I'll try to reproduct this

[Jonas Borgström]

Fixed in r3159.