Bug#474580: [Bug#474580: python-mysqldb: Missing support for TEXT data type]
On 14/04/2008 Andy Dustman wrote: It should be returning TEXT columns as unicode... Can you file a bug in my Sourceforge tracker and reference the Debian bug? Otherwise I tend to lose track of these things. A test case would be nice, though I am pretty sure I test for this in my test suite and it works. Hello Andy, hey Christoph, Just wanted to inform you that I filed the bug in the sourceforge tracker. It can be found at https://sourceforge.net/tracker/index.php?func=detailaid=1964895group_id=22307atid=374932 greetings, jonas -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#474580: [Bug#474580: python-mysqldb: Missing support for TEXT data type]
Hello Andy, We received a bugreport against Mysql-Python (1.2.2): support for data type TEXT seems to be missing. Would be great if you could take a look at it. Please see below. greetings, jonas - Forwarded message from Christoph Burgmer [EMAIL PROTECTED] - Date: Sun, 06 Apr 2008 18:23:43 +0200 From: Christoph Burgmer [EMAIL PROTECTED] Subject: [Python-modules-team] Bug#474580: python-mysqldb: Missing support for TEXT data type To: Debian Bug Tracking System [EMAIL PROTECTED] Reply-To: Christoph Burgmer [EMAIL PROTECTED], [EMAIL PROTECTED] Package: python-mysqldb Version: 1.2.2-6 Severity: normal MySQLdb seems to miss support for MySQL's data type TEXT. This crops up when handling Unicode encoded strings. TEXT seems to be similar to a BLOB though having textual features on sorting and knows about encoding. [1] The current behaviour towards TEXT data is to return it unencoded though others seem to cover conversion (Unicode). When option use_unicode is set to true MySQLdb will convert the following for types according to the encoding: [2] * FIELD_TYPE.STRING * FIELD_TYPE.VAR_STRING * FIELD_TYPE.VARCHAR * FIELD_TYPE.BLOB The field type definition [3] lacks an explicit definition of the TEXT type and thus I assume further down in the implementation the case of TEXT elements is not covered. As I understand from the MySQL documentation [1] a BLOB shouldn't be converted using some encoding though TEXT should be. I couldn't find a place where the library asks about the actual data type comming from MySQL but adding a new field type and adding it to the conversion method doesn't do the trick. I guess this has to be fixed upstream. Christoph [1] http://dev.mysql.com/doc/refman/5.0/en/blob.html [2] /var/lib/python-support/python2.4/MySQLdb/connections.py [3] /usr/share/python-support/python-mysqldb/MySQLdb/constants/FIELD_TYPE.py -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.22 (PREEMPT) Locale: [EMAIL PROTECTED], LC_CTYPE=zh_CN.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages python-mysqldb depends on: ii libc6 2.7-10 GNU C Library: Shared libraries ii libmysqlclient15off 5.0.51a-3 MySQL database client library ii python2.4.4-6An interactive high-level object-o ii python-support0.7.7 automated rebuilding support for P python-mysqldb recommends no packages. -- no debconf information ___ Python-modules-team mailing list [EMAIL PROTECTED] http://lists.alioth.debian.org/mailman/listinfo/python-modules-team - End forwarded message - -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#474580: python-mysqldb: Missing support for TEXT data type
Package: python-mysqldb Version: 1.2.2-6 Severity: normal MySQLdb seems to miss support for MySQL's data type TEXT. This crops up when handling Unicode encoded strings. TEXT seems to be similar to a BLOB though having textual features on sorting and knows about encoding. [1] The current behaviour towards TEXT data is to return it unencoded though others seem to cover conversion (Unicode). When option use_unicode is set to true MySQLdb will convert the following for types according to the encoding: [2] * FIELD_TYPE.STRING * FIELD_TYPE.VAR_STRING * FIELD_TYPE.VARCHAR * FIELD_TYPE.BLOB The field type definition [3] lacks an explicit definition of the TEXT type and thus I assume further down in the implementation the case of TEXT elements is not covered. As I understand from the MySQL documentation [1] a BLOB shouldn't be converted using some encoding though TEXT should be. I couldn't find a place where the library asks about the actual data type comming from MySQL but adding a new field type and adding it to the conversion method doesn't do the trick. I guess this has to be fixed upstream. Christoph [1] http://dev.mysql.com/doc/refman/5.0/en/blob.html [2] /var/lib/python-support/python2.4/MySQLdb/connections.py [3] /usr/share/python-support/python-mysqldb/MySQLdb/constants/FIELD_TYPE.py -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.22 (PREEMPT) Locale: [EMAIL PROTECTED], LC_CTYPE=zh_CN.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages python-mysqldb depends on: ii libc6 2.7-10 GNU C Library: Shared libraries ii libmysqlclient15off 5.0.51a-3 MySQL database client library ii python2.4.4-6An interactive high-level object-o ii python-support0.7.7 automated rebuilding support for P python-mysqldb recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]