MySQL Bugs: #30818: isNULL empty Text fields

Bug #30818	isNULL empty Text fields
Submitted:	5 Sep 2007 8:17	Modified:	6 Sep 2007 10:54
Reporter:	Oscar Tordera	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.19	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
i have an aplication running in Asp.vbscript and MySql and im having problems with the next code

Set Conn = Server.CreateObject("ADODB.Connection")
sConnection = "Driver={MySQL ODBC 3.51 Driver};" & "Server=...;uid=...;pwd=...;database=torres;option=3;"
Conn.Open(sConnection)

miApp="TDL"

set rslan = Server.CreateObject("ADODB.RecordSet")
sqllan = "SELECT * FROM " & miApp & "Descripcion WHERE Nombre like 'pie'"
rslan.Open sqllan,Conn

if not rslan.EOF then
	response.Write("antes " & len(rslan("Texto")) & " antes")
	response.Write("<br>IsNULL -> " & isNULL(rslan("Texto")) & "<br>")
	response.Write("despues " & len(rslan("Texto")) & " despues")
end if

the first response.write prints 351 and the last 0 the instruction isNULL seems to empty all Text fields of my recordset

How to repeat:
I think making a select of a text field printing a text field testing if IsNull and then printing the content again

Hi Oscar and thanks for your report. You have stated two problems here:
 1) RecordSet persistance
 2) IFNULL testing
There are bug reports describing both problems already in BugsDB, I'll find them and see if they truly describe your case. In the meantime please post as much info as possible:
 - MyODBC version
 - MySQL server version
 - OS details
and attach
 - full self-contained test case (or add SQL script with all the data necessary for testing)

Thanks Tonci and sorry for miss information.

MyOdbc version: 3.51.12 (tested too with 3.51.19)
MySql version: 5.0.18-nt
Os Windows 2003 Server R2 Standar Edition Service Pack1

I think thats all

script with database

Attachment: torres.sql (application/octet-stream, text), 1.49 KiB.

Oscar, this is a duplicate of Bug#28891 which is, in turn, duplicate of Bug#27458. Please see discussion there.

Thanks Tonci, I make a mistake with my versions im so sorry.

MySQL 5.0.27-comunity-nt
ODBC 3.51.19
Os I suppose w2003 server (its a hosting company and i dont know exactly)

Excuse me for the mistake

Oscar, no worries. Hope this will get fixed soon.

Thanks for your interest in MySQL.

Oscar, new info posted in Bug#28891.