Symbols and character sets

[Jorge Sanchez]

Hi everyone,

I'm using a VBA Word 2003 macro to upload some text to a MySQL5 database via ADODB. The text is copied directly from a Word document to the SQL statements. Everything works fine except for symbols. I noticed that they are not stored correctly in the table field. The table field is a MEDIUMBLOB so it shoudln't be affected by character sets because it's a binary string. However, when I fetch the data and display it in an HTML page, symbols are displayed as a '?' character on the browser.
Has anyone encountered the same problem before?

Cheers,

Jorge