Replace ’ with '

[subh]

Can you please tell me that how did you replace " ’ " (&rsquo) with " ' " (single quote) ?

[traq]

most text editors can do find-and-replace. you could even use php ( str_replace() ).

Of course, the best solution is to not use MS Word for anything web-related.

[subh]

Thanks Traq,

I have used str_replace() and also ereg_replace() and many other functions.
But my PHP code is not able to read " ’ " symbol even strpos() dont find place of " ’ ".
So I found that there is a problem related to database text encode.

I have entered " ’ " by mistake in database in more than 20000 manual entries.

So I used following query to replace " ’ " in all entries :

update table_name set field_name = replace(field_name, "’", "'")

Thats it now no need to replace " ’ " in php. I have resolved my issues.

Thanks a lot for reply.

[traq]

subh;10990380 wrote:

my PHP code is not able to read " ’ " symbol even strpos() dont find place of " ’ ".

that's very odd.

I'm glad you resolved your problem, though.

[johanafm]

Are you certain you were looking for the proper character? There are after all several characters that may look like the same one if you do not pay attention

'   - straight single quote character
‘   - typograhical opening single quote character
’   - typograhical closing single quote character
′   - prime character, used to indicate inches among other things
´  - acute accent

The prime and typograhical closing single quote may look identical in some fonts. But the typographical closing single quote is unicode character 8217 while the prime character is unicode character 8242