Re: [Sqlalchemy-tickets] [sqlalchemy] #2906: Unicode/UnicodeText return str instead of unicode on M
Brought to you by:
zzzeek
Menu
▾
▴
Re: [Sqlalchemy-tickets] [sqlalchemy] #2906: Unicode/UnicodeText return str instead of unicode on MySQL-Python 1.2.3
|
From: sqlalchemy <mi...@zz...> - 2014-01-10 19:45:06
|
#2906: Unicode/UnicodeText return str instead of unicode on MySQL-Python 1.2.3
----------------------------------+------------------------------------
Reporter: stevejohnson | Owner:
Type: defect | Status: new
Priority: medium | Milestone:
Component: mysql | Severity: no triage selected yet
Resolution: | Keywords:
Progress State: awaiting triage |
----------------------------------+------------------------------------
Comment (by stevejohnson):
I agree that it's weird. It may take me some time to get to the bottom of
things but I'll do my best.
For now, here's the debug output of my original demo:
{{{
2014-01-10 11:41:17,010 INFO sqlalchemy.engine.base.Engine SELECT
DATABASE()
2014-01-10 11:41:17,012 INFO sqlalchemy.engine.base.Engine ()
2014-01-10 11:41:17,012 DEBUG sqlalchemy.engine.base.Engine Col
('DATABASE()',)
2014-01-10 11:41:17,013 DEBUG sqlalchemy.engine.base.Engine Row
(u'graffiti_world_services',)
2014-01-10 11:41:17,015 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES
LIKE 'character_set%%'
2014-01-10 11:41:17,018 INFO sqlalchemy.engine.base.Engine ()
2014-01-10 11:41:17,019 DEBUG sqlalchemy.engine.base.Engine Col
('Variable_name', 'Value')
2014-01-10 11:41:17,019 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_client', u'utf8')
2014-01-10 11:41:17,019 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_connection', u'utf8')
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_database', u'utf8')
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_filesystem', u'binary')
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_results', u'utf8')
### could this be related? ###
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_server', u'latin1')
###
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_set_system', u'utf8')
2014-01-10 11:41:17,020 DEBUG sqlalchemy.engine.base.Engine Row
(u'character_sets_dir', u'/usr/share/mysql/charsets/')
2014-01-10 11:41:17,021 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES
LIKE 'sql_mode'
2014-01-10 11:41:17,021 INFO sqlalchemy.engine.base.Engine ()
2014-01-10 11:41:17,021 DEBUG sqlalchemy.engine.base.Engine Col
('Variable_name', 'Value')
2014-01-10 11:41:17,021 DEBUG sqlalchemy.engine.base.Engine Row
(u'sql_mode', u'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION')
2014-01-10 11:41:17,022 INFO sqlalchemy.engine.base.Engine DESCRIBE
`demo_table`
2014-01-10 11:41:17,022 INFO sqlalchemy.engine.base.Engine ()
2014-01-10 11:41:17,023 DEBUG sqlalchemy.engine.base.Engine Col ('Field',
'Type', 'Null', 'Key', 'Default', 'Extra')
2014-01-10 11:41:17,024 DEBUG sqlalchemy.engine.base.Engine Row (u'id',
u'int(11)', u'NO', u'PRI', None, u'auto_increment')
2014-01-10 11:41:17,025 INFO sqlalchemy.engine.base.Engine BEGIN
(implicit)
2014-01-10 11:41:17,026 INFO sqlalchemy.engine.base.Engine INSERT INTO
demo_table (unicode_text) VALUES (%s)
2014-01-10 11:41:17,029 INFO sqlalchemy.engine.base.Engine ('What a lovely
day',)
MySQL2014-01-10 11:41:17,030 INFO sqlalchemy.engine.base.Engine SELECT
version() AS version_1
2014-01-10 11:41:17,030 INFO sqlalchemy.engine.base.Engine ()
2014-01-10 11:41:17,030 DEBUG sqlalchemy.engine.base.Engine Col
('version_1',)
2014-01-10 11:41:17,031 DEBUG sqlalchemy.engine.base.Engine Row
(u'5.6.13-2+debphp.org~precise+2',)
5.6.13-2+debphp.org~precise+2
sqlalchemy 0.8.4
MySQL-Python 1.2.3
2014-01-10 11:41:17,032 INFO sqlalchemy.engine.base.Engine SELECT
demo_table.id AS demo_table_id, demo_table.unicode_text AS
demo_table_unicode_text
FROM demo_table
LIMIT %s
2014-01-10 11:41:17,032 INFO sqlalchemy.engine.base.Engine (1,)
2014-01-10 11:41:17,033 DEBUG sqlalchemy.engine.base.Engine Col
('demo_table_id', 'demo_table_unicode_text')
2014-01-10 11:41:17,033 DEBUG sqlalchemy.engine.base.Engine Row (21L,
'What a lovely day')
<type 'str'>
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2906#comment:4>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
