ansaurus

Question

Strange problem of apostrophe in communicating with PHP script from Android

Answer 1

+2 A:

This is not UTF-8 encoding, it's called URL or percent encoding. Try running the data through urldecode() before inserting it into the data base.

Pekka 2010-07-14 09:46:40

In PHP we have used the same thing i.e urldecode() but still the problem persists. Can you let me know what is the problem?

sunil 2010-07-14 11:00:43

@sunil please show the code you are using to insert the data.

Pekka 2010-07-14 11:02:19

That's the problem I don't have access to the PHP code. Can you let me know whether its decoding issue or inserting into MySQl?

sunil 2010-07-14 11:03:56

@sunil I'm afraid that is impossible to tell without seeing the code.

Pekka 2010-07-14 11:04:26

Can you provide me a sample where you have used urldecoding and inserting into mysql? It will be of great help if you can.

sunil 2010-07-14 11:23:13

@sunil a simple `$string = $_POST["string"]; $string = urldecode($string);` ... and then insert into the database using the DB of your choice. If you're using old style mySQL functions instead of PDO, don't forget ` $string = mysql_real_escape_string($string);`

Pekka 2010-07-14 11:41:41

Answer 2

+1 A:

urldecode(rawurldecode("Today%27s+Horoscope"));

as Pekka pointed out urldecode is sufficient in this case, this is mainly (overdone) precaution since I've seen urldecode failing

DrColossos 2010-07-14 09:48:07

Is the `rawurldecode` really necessary though? Doesn't `urlencode()` handle both things?

Pekka 2010-07-14 09:50:28

You're right but I've seen cases where only both gave the proper solution, no idea why but in this case, `urldecode()` is enough. I just always use both to make sure...

DrColossos 2010-07-14 09:55:01

if you have a % sign in text double decoding will break your text.

Naktibalda 2010-07-14 09:59:17

Answer 3

A:

I tried your example in the php code and couldn't get the error as you mentioned.

$str = "Today's Horoscope";

echo $str; //Today's Horoscope

echo "Encoded: ".urlencode($str); //Encoded: Today%27s+Horoscope

echo "Decoded: ".urldecode($str); //Decoded: Today's Horoscope

If you would like to escape the quotes before inserting to the database use mysql_real_escape_string($str);

Webrsk 2010-08-03 10:42:17

ansaurus

tags:

views:

answers:

Strange problem of apostrophe in communicating with PHP script from Android

related questions