Re: Python and MySQL 4.1

From: Michael Fuhr (mfuhr_at_fuhr.org)
Date: 10/31/04 

Date: 30 Oct 2004 23:07:31 -0600

"webdsine" <webdsine@yahoo.ca> writes:

> Hello. I just upgrade to MySQL 4.1 from 4.0, and I'm having trouble
> retrieving text from the DB in the proper format using the MySQLdb
> module in Python. All text fields that are retrieved are in this
> format:
>
> array('c', 'Whatever is in the field')

> The only data that's not displayed in that format are enum values, and
> when I was still in v4.0 only 'Whatever is in the field' is
> retrieved.

Could you post an example that demonstrates the problem? It would
be helpful to see the CREATE TABLE and INSERT statements that show
what the data looks like, the Python code that shows how you're
retrieving the data, the program's output with MySQL 4.0, and the
program's output with MySQL 4.1. 

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Relevant Pages

  • Re: MYSQL and use of blobs
    ... > information was stored in the blob. ... > So, when reading back that information into my python environment, it ... fileData = open.read ... other than retrieving and decompressing the data. ...
    (comp.lang.python)
  • Re: Python and MySQL 4.1
    ... > retrieving text from the DB in the proper format using the MySQLdb ... > module in Python. ...
    (comp.lang.python)
  • Python and MySQL 4.1
    ... retrieving text from the DB in the proper format using the MySQLdb ... I've completed my Python application ...
    (comp.lang.python)
  • Re: password() and select statement
    ... I have a problem in retrieving a row form a table that I created in ... echo "Acces denied. ... What versions are the MySQL server and the client libraries you're using in PHP? ...
    (comp.lang.php)
  • Re: store object in database
    ... > while retrieving, i am getting a class cast exception when i am trying ... As far as I know, mysql is not an OO database, so you can't store objects ...
    (comp.lang.java.help)