Escaping characters

Brought to you by: espiridiao

#3 Escaping characters

Status: open

Owner: Jorge Espiridiăo

Labels: Improvements (3)

Priority: 8

Updated: 2003-01-30

Created: 2003-01-11

Creator: Adam Alkins

Private: No

It'll be good if special characters would be escaped
when converted. I have to manually escape them for
MySQL. Great program though.

Discussion

Jorge Espiridiăo - 2003-01-27

assigned_to: nobody --> espiridiao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jorge Espiridiăo - 2003-01-30

Logged In: YES
user_id=481192

I don't understan what you meen. Can you send me a example
with Access2SQL output and the input to MySQL after you had
changed? Regards.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jorge Espiridiăo - 2003-01-30

labels: --> Improvements

priority: 5 --> 8
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Adam Alkins - 2003-02-02

Logged In: YES
user_id=512156

It happens with quotes, like ". Access2SQL encloses fields
with the double quote " ", however, if a field value
contains the character ", it doesn't convert it to \&quot;.

e.g., if in Access I had a field value, literally, This
character, ", is a quote character, then when I do the
conversion, the SQL will be

INSERT INTO [...] ("This character, ", is a quote
character", "......

insert of

INSERT INTO [...] ("This character, \&quot;, is a quote
character", "......

Understand?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Adam Alkins - 2003-02-03

Logged In: YES
user_id=512156

Ooops type, "insert of" should be "instead of" :o

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.