MySQL Bugs: #56210: Wierd thing happen when checking for empty strings

Bug #56210	Wierd thing happen when checking for empty strings
Submitted:	24 Aug 2010 5:46	Modified:	24 Sep 2010 7:07
Reporter:	Jerry Potokar	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S2 (Serious)
Version:	all 5.5	OS:	Windows (IIS 7.0)
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	myodbc character set null

Description:
Hi there

I user mysql 5.5.5 and myODBC 5.1.6. I programm in ASP.

I have a text column that have null values by default. If I do a

response.write on a column I get some wierd non latin characters out ;-(

橁潤⁶潭跄楮⁫⁺番쑲殍i

This should be read: Močnik s klobaso Of course comparing now like if column<>"" doesn't work as it writes a type error of course.

How to repeat:
Make a text column in database. Default should be null. Make some cells null and some have text includin our characters: čšđćžČŠĐĆŽ.

Try to read the column using myODBC / ASP Vbscript.

Hi Jerry and thanks for your report.

"Močnik s klobaso" hehehe
Now, seriously, can you do the following:
  o Try the same queries against same server but from some client like WB or odbctexx. Report the results back.
  o Do attach complete test case so I can load it in my IIS.
  o Do check charsets used on server.

I think this might be some charset misconfiguration between MySQL server and IIS.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".