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:Microsoft Windows (IIS 7.0)
Assigned to: Assigned Account CPU Architecture:Any
Tags: myodbc character set null

[24 Aug 2010 5:46] Jerry Potokar
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.
[24 Aug 2010 7:07] Tonci Grgin
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.
[24 Sep 2010 23:00] Bugs System
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".