Bug #33609 While getting datetime value it returns ????? value
Submitted: 1 Jan 2008 17:54 Modified: 2 Jan 2008 7:56
Reporter: Reha Biçer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: datetime value

[1 Jan 2008 17:54] Reha Biçer
Description:
Here is simple SQL sentence;

SELECT tarih FROM tablo

I am getting ????? value of tarih field.

Tested on IIS 6.0 Windows 2003 Server using ASP code.

Tarih = Rs.Fields("tarih").value

How to repeat:
Everytime it repeats.

Suggested fix:
To solve problem you have to install previous version of ODBC 3.51.21
[2 Jan 2008 7:56] 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 Reha and thanks for your report. I am sorry I can not repeat it on my box:
 - MySQL server 5.0.54BK on WinXP Pro SP2 localhost
 - MyODBC 3.51.23, rev.968 from 30.12.2007. I see no relevant changes to your problem in ChangeLog.

Please attach as more information as possible to this report (especially DM trace) and re-open it if you're sure there is a bug. I presume you're selecting against older server with CONCAT, for example, thus hitting:
  * Removed workaround for bug #10491 in the server, which has now been
    fixed in MySQL Server 5.0.48 and 5.1.21.
[2 Jan 2008 7:57] Tonci Grgin
ASP page

Attachment: bug33609.asp (application/octet-stream, text), 1.37 KiB.