Find Jobs
Hire Freelancers

Convert Content In MySQL coming from Different Encoding into utf8

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
We have a new CMS application where we imported data from the databases of multiple websites. Some of these websites were using utf8 encoding while others were using iso-8859 etc. After the import, some of the content has been edited and some are same as before. We have the old as well as new databases. We would like a PHP script, which can: 1. Take the new database (one column each from a few tables) and detect its encoding and convert them all into utf8 2. Ensure that the data has no special or non-printable characters left.
Project ID: 6056500

About the project

8 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I am a database expert and would be able to write the script for you. Please let me know if you would like me to do the job. Thanks Deb
$75 USD in 3 days
4.6 (6 reviews)
3.7
3.7
8 freelancers are bidding on average $138 USD for this job
User Avatar
Hello, You want only the PHP script? Could I do this with Java? If you agree with using Java, I can do it for you. Thanks! Van Pham.
$166 USD in 4 days
5.0 (5 reviews)
3.0
3.0
User Avatar
Hi there, I'm an experienced front/end and mobile web developper and i usually work with checkpoints, for example, i work to reach each point that employer had specified on a document. When i reach it i will receive payment for each point that i complete. I can build your project with better performance using phalcon framework wish is the most faster php framework, beauty with bootstrap and elements costumization, dynamic content with jquery and ajax calls. Pm me, we can talk through skype if you want. Best Regards, Armando Freitas.
$150 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Mr/Mrs, I am a Senior Software Engineer with vast experience in infrastructure and dev ops. I invite you to see my profile in Freelancer for further info, or just ask for my resume and will be happy to give it to you. I see 3 ways to solve your problem: 1) Use a PHP script as you request to get data from the source with some encoding (i.e. ISO-8859) and propagate it to the target database encoded in UTF8. 2) Use a MySQL script to convert the data into the database. 3) Use MySQL utils (such as mysqldump) and shell scripting. Unless you require it, I would prevent to use high level languages such as PHP, as other considerations may be needed. If possible the conversion should happen in a temporary database before getting the final result. Also, you should consider how the data is read from the database, because if MySQL keeps UTF8 data and you should not setup PHP to handle the same encoding your result will not be as expected in the front-end. I hope my explanation is clear. Please let me know if you have further questions. Good luck with your project. Thanks in advance. Best Regards, dipl-Eng. Esteban I. Storch
$122 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do in developing a comparative php script to convert and insert the data from any encoding to encoding utf8 in another database.
$90 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am ready for work. It shouldn't take a long time to complete this task. I have experience with PHP and databases.
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
PUNE, India
5.0
2
Payment method verified
Member since Oct 15, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.