René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"MySQL - \"'ascii' codec can't encode character\" with accentuated character in the table name","articleBody":"```\nWhat steps will reproduce the problem?\n1. Create a table with an accentuated character in the name, like \"pdf_imprimé\"\n2. run sqlautocode\n\nWhat is the expected output? What do you see instead?\n$ sqlautocode mysql://[...]/db -d -e -o model.py\nsaac.decl - INFO - Reflecting database...\n[...]\nsaac.decl - DEBUG - Creating Model from table: pdf_imprimé\nTraceback (most recent call last):\n  File \"/usr/local/bin/sqlautocode\", line 9, in \u003cmodule\u003e\n    load_entry_point('sqlautocode==0.7', 'console_scripts', 'sqlautocode')()\n  File \"/usr/local/lib/python2.6/dist-packages/sqlautocode/main.py\", line 21, in main\n    emit(repr(factory))\n  File \"/usr/local/lib/python2.6/dist-packages/sqlautocode/declarative.py\", line 143, in __repr__\n    models = self.models\n  File \"/usr/local/lib/python2.6/dist-packages/sqlautocode/declarative.py\", line 192, in models\n    self._models.append(self.create_model(table))\n  File \"/usr/local/lib/python2.6/dist-packages/sqlautocode/declarative.py\", line 234, in create_model\n    class Temporal(self.DeclarativeBase):\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/ext/declarative.py\", line 1336, in __init__\n    _as_declarative(cls, classname, cls.__dict__)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/ext/declarative.py\", line 1329, in _as_declarative\n    **mapper_args)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/__init__.py\", line 1116, in mapper\n    return Mapper(class_, local_table, *args, **params)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/mapper.py\", line 201, in __init__\n    self._configure_properties()\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/mapper.py\", line 851, in _configure_properties\n    setparent=True)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/mapper.py\", line 1139, in _configure_property\n    prop.instrument_class(self)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/properties.py\", line 111, in instrument_class\n    doc=self.doc\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/attributes.py\", line 1293, in register_descriptor\n    manager.instrument_attribute(key, descriptor)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/instrumentation.py\", line 182, in instrument_attribute\n    self.install_descriptor(key, inst)\n  File \"/usr/local/lib/python2.6/dist-packages/sqlalchemy/orm/instrumentation.py\", line 236, in install_descriptor\n    setattr(self.class_, key, inst)\nUnicodeEncodeError: 'ascii' codec can't encode character u'\\xe9' in position \n20: ordinal not in range(128)\n\n\nWhat version of the product are you using? On what operating system?\nPython 2.6.5 on Linux (I have the same problem with Python 2.7.1 on Windows)\nsqlautocode-0.7\n\nPlease provide any additional information below.\nI also use columns with accentuated characters.\n```\n\nOriginal issue reported on code.google.com by `bigras.b...@gmail.com` on 6 Feb 2012 at 3:07\n","author":{"url":"https://github.com/GoogleCodeExporter","@type":"Person","name":"GoogleCodeExporter"},"datePublished":"2015-12-02T03:31:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/37/sqlautocode/issues/37"}