RE: [PHP-DB] Special Character

I you use a SQL adapter, like ADO, it could do the htmlentities it self... However, if you would like to change this, note that oracle will consider some chars as 'special chars', like (if I remember well) the &. To be able to insert a string with these chars, you need to search/replace them by their ascii value (use the Oracle function chr() This is specially true when inserting urls. vincent -----Original Message----- From: Chris [mailto:dmagick@gmail.com] Sent: Wed 22/11/2006 22:17 To: David Skyers Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Special Character David Skyers wrote: > Hi Kevin, > > Thanks for this, it got rid of my special characters. However I now have a problem with foreign > characters. > > Example > > 'De l'Âge du fer au haut Moyen Âge.' > > gets inserted into oracle as > > De l'Âge du fer au haut Moyen Âge. > > I have an oracle procedure that inserts the data, if I run the oracle procedure directly in > oracle it inserts the special characters okay. The problem seems to be with the way php execute the > procedure. Are you calling htmlentities or htmlspecialchars before calling the procedure? That looks like what's happening. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php