Bug #30496 mysql odbc TEXT field return 'x' When value is Null or Empty
Submitted: 19 Aug 2007 8:28 Modified: 25 Jan 2009 14:56
Reporter: jie zhang Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51.17 OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any
Tags: empty, null, RETURN 'X', TEXT FIELD

[19 Aug 2007 8:28] jie zhang 
Description:

mysql odbc  TEXT field  return  'x'  When value is Null  or Empty

How to repeat:
ALWAYS
[20 Aug 2007 5:40] Tonci Grgin 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Explanation: Hi Jie and thanks for your report. Please, always attach as much info as possible. Do add standalone test case too. Did you tried 3.51.19 as 3.51.17 is rather old?
[25 Jan 2009 0:51] Matthew Adams 
This is exactly the same problem I have - did you find a solution?
My connection string was

Driver={MySQL ODBC 3.51 Driver};Server=***;Port=3306;Database=enrol;User=* ***;Password=***;Option=3;"

Using version 5.0.45
[25 Jan 2009 14:55] Tonci Grgin 
Matthew, Jie, it is not my job to write test case based on various claims. I asked for repeatable test case, but none responded. So I found on written by Bogdan: Bug#23264.

Also, this report seems to be duplicate of that one and I'm marking it as such. We'll continue investigation in original report.
[25 Jan 2009 14:56] Tonci Grgin 
Closing as duplicate of Bug#23264, reopening original report for investigation.
[26 Jan 2009 16:21] Jess Balint 
Matthew, What version of the ODBC driver are you using?