By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Attaching to MySQL tables from MS Access - apostrophes { Chr$(39) } in memo fields are somhow expanded to a 4-character string ("&#39")

P: n/a
Is an apostrophe a character of special significance to MySQL in a way
that would cause "Bob's dog" to become translated into a 12-character
string when typed into a MySQL memo field? If I type Bob's dog into an
Access memo field, I get a string that is 9-characters long.

When I read "Bob's dog" from a memo field in a MySQL table attacted
to MS Access via MyODBC driver, it displays as "Bob&#39s dog" - a
twelve character string. the &#39 looks like a HEX character code
value designator. Can someone provide me with a logical explanation
of why I might be seeing apostrophes this way from an MS Access
database having such tables attached?
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.