RE: [PHP-DB] Special Character
| From: | David Skyers | Date: | Thu, 23 Nov 2006 09:29:24 +0000 |
| Subject: | RE: [PHP-DB] Special Character | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42734@lists.php.net to get a copy of this message | ||
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@gmail.com]
Sent: 22 November 2006 21: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/