Empty fields returning as gibberish in recordset

The version of ASP is 4.0.2L

When selecting data from a Mysql database, empty fields seem to randomly be assigned values.

These values often change upon ech code execution, but sometimes stay the same for a while.

These values are not always assigned - ie sometimes the field returns as "" (like it should).

Here is an example: "]旆a?hF?hF?"

But when looking in the database the value is actually ""

Has anyone had this before or does anyone know of a workaround?

[507 byte] By [codecdoga] at [2007-11-27 8:07:20]
# 1
What version of MysqlWhat are the column names and types.My bet is you are running Mysql V5Duncan
Duncan_Berrimana at 2007-7-12 19:50:02 > top of Java-index,Web & Directory Servers,Web Servers...