single &double quotes in identifiers (table & field names)

General usage of Access to MySQL

Moderator: jr

single &double quotes in identifiers (table & field names)

Postby Koy » Sun Feb 26, 2017 10:02 pm

Access does allow table names and field names to have single and double quotes in them. But they don't work very well in SQL.

I suggest having an option to filter them out, or at a minimum flagging them before the conversion process starts so that the user can remove them in Access before proceeding.

In the past I had Access table names like this:

Sharon's costs

And Access field names like this:

len' -for length in feet
len" - for length in inches

(This was nice because it kept field names short. Much better than len-inches or len-in or len(i) or iLen.)
Koy
 
Posts: 0
Joined: Sun Feb 26, 2017 9:42 pm

Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron