distal-attribute
distal-attribute
distal-attribute
distal-attribute

replacing double quotes with back ticks - follow up question

User, date Message
Written by helpme
3 years ago
Category: Import/Export
14 posts since Wed, 08 Jul 09
Anse, one of the fields in my SQL file is a MEDIUMTEXT field, and has conversational sentences that contain double quotes as part of human conversations.

So if I do a general search and replace of double quotes for back ticks, that will create all the double quotes as conversation within the MEDIUMTEXT field to get converted too.

Would that cause the import to fail?

I did a small test and it looks like it will still import correctly, just that the conversation threads will look like they have back ticks instead of double quotes in them.


Small Issue #2

Also, I noticed that any of these conditional commands seem to muck up the import too:

/*!40000 ALTER TABLE "post" DISABLE KEYS;*/

It only works when I delete all of them. Any way around that too? Should I just delete them or is there a way to keep them in there.
Written by helpme
3 years ago
14 posts since Wed, 08 Jul 09
I believe another problem with searching and replacing double quotes for back ticks is MEDIUMBLOB which is used to store images. I find " double quotes used to store image data, which changes the image when they're changed to back ticks...
Written by ansgar
3 years ago
4783 posts since Fri, 07 Apr 06
Why the heck do you post a second thread as a follow up to another thread? Makes it difficult to get the overview of all your problems, man.
 

Please login to leave a reply, or register at first.