Hi Chris, Yes, I was using htmlentities, I have now removed that and now 'De l'Âge du fer au haut Moyen Âge.' gets inserted into oracle as 'De l'Bge du fer au haut Moyen Bge.' Any ideas? David -----Original Message----- From: Chris [mailto:dmagick@xxxxxxxxx] Sent: 22 November 2006 21:17 To: David Skyers Cc: php-db@xxxxxxxxxxxxx Subject: Re: 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
