MySQL Bugs: #17300: Error converting Access text fields that begin or end with apostrophe

Bug #17300	Error converting Access text fields that begin or end with apostrophe
Submitted:	10 Feb 2006 12:54	Modified:	11 Feb 2006 14:38
Reporter:	Kim Watt	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.0.23 rc	OS:	Windows (Windows XP)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When migrating an Access database, text fields that begin or end with an apostrophe fail with "You have an error in your SQL syntax." Apostrophes appearing anywhere else in the text field transfer ok.

How to repeat:
Migrate an access database containing a text field, data begins or ends with an apostrophe.

I was unable to repeat. Could you please shows a sample text which
provoked the issue on your side. Thanks in advance.

 Number of migrated schemata: 1

  Schema Name:            db25
  - Tables:               1
  - Views:                0
  - Routines:             0
  - Routine Groups:       0
  - Synonyms:             0
  - Structured Types:     0
  - Sequences:            0

  Details:

  - Tables
      `db25`.`tb25`
      -------------
  - Views
  - Routines
  - Routine Groups
  - Synonyms
  - Structured Types
  - Sequences

2. Data Bulk Transfer
---------------------

      `db25`.`tb25`
      -------------
          2 row(s) transfered.

c:\mysql\bin>mysql -uroot db25
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from tb25;
+----------------------+---------------+
| col1                 | col2          |
+----------------------+---------------+
| 'this test at begin' | 'another one' |
| select'              | 'happy again  |
+----------------------+---------------+
2 rows in set (0.13 sec)