I had an issue. I do not want to insert ’ to the database.
Because when reading the ’ it will turn out with funny character.
Is there a way to prevent or encode ’ to ' when inserting to MySQL?
Asked
Active
Viewed 42 times
0
Alive to die - Anant
- 70,531
- 10
- 51
- 98
DANLEE
- 443
- 1
- 8
- 25
-
Replace this character with js before saving. – Jai Jul 26 '16 at 04:33
-
can it be done using php? – DANLEE Jul 26 '16 at 04:37
-
@Danlee absolutely! Take a tour of php.net docs. – Jai Jul 26 '16 at 04:46
-
1http://php.net/manual/en/function.iconv.php and it's example is in given link of Michael_B which is `$output = iconv('UTF-8', 'ASCII//TRANSLIT', $input);` – Alive to die - Anant Jul 26 '16 at 04:53
-
Can you set this as an answer so I can mark off? – DANLEE Jul 27 '16 at 06:37
1 Answers
0
If you just want to replace that specific string why not just doing:
$encoded = str_repace("’","'",$input);
Jose Garrido
- 732
- 1
- 15
- 31