Hi,

You can maybe have a problem between a UTF-8 webserver and a ASCII (latin  or whatever) data
base?
Do you know the default_charset of your webserver (check the php.ini) and do you know the ch
arset of your database? and the charset of your oracle client ? all 3 will play a role...

this : 'De l'Bge du fer au haut Moyen Bge.' really looks like inserting a UTF/unicode char i
nto a ascii (latin, ...) database...


I think the best solution would be to keep the htmlentities to store the chars into the data
base, no?
this way would ensure you insert only 'simple' chars, at least as long as you do not enter c
hinese or foreign chars in your website.

vincent



-----Original Message-----
From: David Skyers [mailto:d.skyers@[...].uk]
Sent: Thu 23/11/2006 10:29
To: Chris
Cc: php-db@[...].net
Subject: RE: [PHP-DB] Special Character
 
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@[...].com] 
Sent: 22 November 2006 21:17
To: David Skyers
Cc: php-db@[...].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 fo
reign 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 i
n oracle it inserts the special characters okay. The problem seems to be with the way php ex
ecute the procedure.

Are you calling htmlentities or htmlspecialchars before calling the procedure? That looks li
ke 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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php