Bad Metadata w/ PHP5 & Mysql

[dromano]

Okay, so i'm seeing a very bizarre issue with results from queries to the database.

I make a simple query such as:

SELECT foo FROM thetable WHERE id = 1

I run the query and then store the results as so:

$row = mysql_fetch_assoc($result);

for testing purposes i print_r($row) to see what i'm looking at. the result i get is this:

Array(
[#B] => some value
)

The metadata (at least i think that is what it is called) is incorrect, in most cases it would be:

Array(
[foo] => some value
)

Has anyone see this before? The same scripts worked fine before migrating to php5. Any help would be great.

[bastien]

It works fine. Trying reading the manual.

from: http://ca3.php.net/manual/en/function.mysql-fetch-assoc.php
array mysql_fetch_assoc ( resource result)

Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.

[dromano]

This i know. Obvioulsy the mysql_fetch_assoc is working. My issue is that the key is wrong. Why would the key be incorrect? in the example i provided it should have been $row['foo'] but there is no $row['foo']. My quess is that the connection to the database is running into issues with character sets, but i don't know why. All i wanted to know was if anyone else has seen this issue. Perhaps this has happened before when migrating from php4 to php5.