Hi,
Me again, running into problems if my data contains accented characters,
e.g. 'é'.
This is still with Py3.4 and SQLAlchemy 0.9.6.
sqlalchemy.exc.DatabaseError: (DatabaseError) ('Error while executing
SQL statement:\n- SQLCODE: -303\n- Dynamic SQL Error\n- SQL error code =
-303\n- Malformed string', -303, 335544569) 'INSERT INTO language (id,
name, code2, code5, created_at, updated_at, created_by, updated_by)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)' ((1, 'English', 'en', 'en_EN',
datetime.datetime(2014, 7, 9, 16, 4, 9, 2963), None, None, None), (2,
'Français', 'fr', 'fr_FR', datetime.datetime(2014, 7, 9, 16, 4, 9,
2963), None, None, None), (3, 'Deutsch', 'de', 'de_DE',
datetime.datetime(2014, 7, 9, 16, 4, 9, 2963), None, None, None), (4,
'English - user defined', 'en', 'en_EN', datetime.datetime(2014, 7, 9,
16, 4, 9, 2963), None, None, None), (6, 'Dansk - support only in
English', 'da', 'da_DA', datetime.datetime(2014, 7, 9, 16, 4, 9, 2963),
None, None, None), (7, 'Néerlandais - support only in English', 'nl',
'nl_NL', datetime.datetime(2014, 7, 9, 16, 4, 9, 2963), None, None, None))
The problem is the 'ç' in Français and the 'é' in Néerlandais.
This worked for me in Py2.7 using kinterbasdb, so I wonder where I need
to search, is it an fbd issue or SA or my source file encoding?
The source file encoding is "# -*- coding: utf-8 -*-" and the SA engine
is setup "engine2 = db2.sa.create_engine(dburl, encoding='utf8',
echo=False)".
Werner