Help storing and retrieving FRENCH characters from MySQL table on LAMP server

$10-30 USD

Avslutat

Publicerad

över ett år sedan

$10-30 USD

Betalning vid leverans

Here is an issue that ChatGPT has not been able to solve with success... I have a MySQL table on a LAMP server and I need to store French text in the records (field type text or longtext or varchar). But when I export the data, those accents come out as strange characters. I tried changing the table's format to UTF8, but strangely it was already a version of UTF8 by default and still I get those strange characters. So to try and solve it, I manually convert all accented characters to html codes (for example: é for é), when I save them. Then I decode them when I get the records out for display. But unfortunately this causes an issue with searching through data. If I need to search for the word "résident" I will not find the word because the text that was saved is "résident". Unfortunately I am unable to find a solution, even with ChatGPT's help. If you are using French characters, and you have experience with this, I need you to explain to me with instructions, how to make this work. I need to be able to save the accented characters, search using the php strpos(string,find,start) function, and export the data either as a flat ASCII file or as an SQL export (insert). This is a very easy thing for someone who is storing French characters. You MUST have experience saving (French) accented characters.

PHP

MySQL

Software Architecture

Linux

JavaScript

Project ID: 35774365

Om projektet

12 anbud

Distansprojekt

Senaste aktivitet ett år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

12 frilansar lägger i genomsnitt anbud på $84 USD för detta uppdrag

@gangabass

I can fix your MySQL FRENCH characters issue in less than an hour for just $30. Could you show your PHP code? Roman

$30 USD Om 1 dag

5,0

(652 omdömen)

8,0

@BitLabs

Dear sir, I have gone through your outsourced requirement " Help storing and retrieving FRENCH characters from MySQL table on LAMP server " and have analyzed that I have right credentials ( PHP JavaScript Linux Software Architecture MySQL ) to execute your esteemed project. You will never go wrong choosing me :)

$20 USD Om 7 dagar

5,0

(136 omdömen)

6,8

@abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I'm good in C#, .Net Core, MVC, ASP.NET, Angular.js, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$30 USD Om 1 dag

4,9

(281 omdömen)

7,2

@softechk

Hello, Greetings! of the day. To store accented characters in MySQL database using PHP correctly, the charset needs to be set in PHP code as follows: 1) If PHP mysql extension is used, the following code should be used after connecting to database: mysql_set_charset("utf8");. 2) If PHP mysqli extension is used, the following code should be used after connecting to database: mysqli_set_charset($conn, "utf8");, where $ conn is database connection variable. 3) If PHP MySQL PDO extension is used, the following code should be used: $pdo = new PDO("mysql:host=localhost;dbname=dbname;charset=utf8", 'my_user', 'my_pass'); On html page, where results are displayed after retrieving data from MySQL, the following code should be used: In HtML head tag, <meta http-equiv="Content-type" content="text/html;charset=utf-8" />. Please check, if this code works at your end. I have much expetiencing in working on projects, using PHP, MySQL. Your work will be done, according to requirements. Thanks.

$20 USD Om 2 dagar

4,9

(65 omdömen)

5,5

@umairkaramat24

Hello, I read your project details and really interested in your mentioned job. I have 5+ years’ experience doing similar jobs related to these skills JavaScript, Linux, Software Architecture, PHP and MySQL. I think its doable job, and really confident to do that. Please start the chart so we have detail discussion about task and finalize it as per your timeline. Regards Umair

$30 USD Om 7 dagar

5,0

(24 omdömen)

5,2

@bizmanas

Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Expert in data engineering. I will be able to help you with the project. Please ping me offline to discuss further.

$600 USD Om 7 dagar