Importing Issue ’

[oMIKEo]

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

[kenrbnsn]

Is the data being stored via Microsoft word? If so, what looks like a simple quote ( ' ) really isn't one.

Ken

[oMIKEo]

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

[kenrbnsn]

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

[oMIKEo]

Thanks,

Problem Fixed :)

Mike