Jump to content

Archived

This topic is now archived and is closed to further replies.

oMIKEo

Importing Issue ’

Recommended Posts

Hi,

Ive been importing all the records for a clients site into my database and ive just exported and then imported them into the clients database but its not working very well...

Its adding things like don’t when it should be a '

Any ideas if i can easily solve this?

Thanks,
Mike

Share this post


Link to post
Share on other sites
Is the data being stored via Microsoft word? If so, what looks like a simple quote ( ' ) really isn't one.

Ken

Share this post


Link to post
Share on other sites
The data was originally in MS Word then pasted into my database via phpmyadmin.

From that the tables and data were extracted as a .sql file and imported into the clients database, again via phpmyadmin.

Any ideas how to fix the problem of those special characters.

Thanks

Share this post


Link to post
Share on other sites
I found this solution on another PHP email list I'm on:
[code]<?php
     $search = array(
         '/[\x07\x95]/',
         '/\x85/',
         '/[\x91\x92]/',
         '/[\x93\x94]/',
     );
     $replace = array(
         '-',
         '...',
         '\'',
         '"',
     );
     $data = preg_replace($search, $replace, $data);
?>[/code]

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.