RE: [PHP-DB] Special Character

Hi, You can maybe have a problem between a UTF-8 webserver and a ASCII (latin or whatever) database? Do you know the default_charset of your webserver (check the php.ini) and do you know the charset 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 into a ascii (latin, ...) database... I think the best solution would be to keep the htmlentities to store the chars into the database, no? this way would ensure you insert only 'simple' chars, at least as long as you do not enter chinese or foreign chars in your website. vincent -----Original Message----- From: David Skyers [mailto:d.skyers@ucl.ac.uk] Sent: Thu 23/11/2006 10:29 To: Chris Cc: php-db@lists.php.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@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/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php