[FX.php List] Continuing problem with parsing apostrophes

[Chris Hansen]

Bob,

I suspect that part of the problem is curly quotes, too.  An entity number that high means that the character in question is not the simple ' but the curly version.  So, as mentioned elsewhere the following will work, but the character is most likely showing up as a result of curly quotes...

html_entity_decode('’', ENT_QUOTES, 'UTF-8')

Best,

--Chris

On Mar 2, 2011, at 8:14 AM, Bob Patin wrote:

> I'm still having trouble with the following:
> 
> I'm reading from one table, doing stuff, and then writing the same record to a new table.
> 
> If the text is something like 
> 
> Bob's
> 
> it displays fine on my page, but when I write it back to the new table, it gets changed to
> 
> Bob’s
> 
> What's the command to make sure that it gets written back to the database properly? I thought it was stripslashes() but I can't seem to get that to do anything.
> 
> Thanks,
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> iChat: bobpatin
> FileMaker 9, 10 & 11 Certified Developer
> Member of FileMaker Business Alliance and FileMaker TechNet
> --
> Expert FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting:
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list