Jump to content


Photo

French accents problem


  • Please log in to reply
4 replies to this topic

#1 BVV

BVV
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 09 November 2005 - 04:09 PM

Hello,

I'm using oci functions to retrieve data from an Oracle database.

When i make an echo of query results, french accents (such as 'é' or 'à') are replaced by characters ('e' or 'a' for instance) without accent.

Can anyone help me ?

Vincent.

#2 Honoré

Honoré
  • Members
  • PipPipPip
  • Advanced Member
  • 66 posts
  • LocationAntwerp - Belgium

Posted 09 November 2005 - 04:33 PM

Verify the characterset in your database and the characterset in your HTTP Headers.

#3 BVV

BVV
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 10 November 2005 - 09:28 AM

Both are good. I'm using iso-8859-1 in HTML pages and I get french accents when I do a query directly on the DB.

I just don't get the accents when I do a query using oci PHP functions.

#4 BVV

BVV
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 November 2005 - 12:20 PM

Actually, I just had to add UTF8 as charset in my ocilogon function.

#5 BVV

BVV
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 29 November 2005 - 11:18 AM

This time, I have a problem with accents when I make an INSERT into the database. All accentuated characters are replaced by ¿¿

Thank for your help.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users