what are the valid characters for an MS Access text or memo field?
and can all this range of characters be represented in the same form that say chr(A) - chr(Z) represents the range for upper case letter A - Z?
I think you can put any characters in the text memo field.
I have run into issues with ODBC getting stuck on ' though.
For example if you try to send:
"John's big red bike"
you might get an odbc error
but if you escape the '
"John''s big red bike"
ODBC is non the wiser.
I'm not sure if this is just a php+access+odbc issue or not, but that's where it bit me.
I think you can put any characters in the text memo field.
I have run into issues with ODBC getting stuck on ' though.
For example if you try to send:
"John's big red bike"
you might get an odbc error
but if you escape the '
"John''s big red bike"
ODBC is non the wiser.
I'm not sure if this is just a php+access+odbc issue or not, but that's where it bit me.
Not sure what you are asking here.
if you insert "John''s big red bike" through embedded sql in ASP, then is will sent like that to the db and access will turn it into "John's big red bike"
but if you insert "John''s big red bike" through embedded sql in PHP, then it will probably automatically addslashes and turn it into "John\'\'s big red bike" and access will choke on it.
So check with get_magic_quotes_gpc() if the values are automatically escaped by PHP.