Re: French characters

["Don Proshetsky" <don@xxxxxxxxxxxxx>]

Thanks.  For the database, there are many UTF8 collations.  Is this the recommended one?
UTF8_unicode-ci?
  ----- Original Message ----- 
  From: Mert Oztekin 
  To: 'Don' ; php-general@xxxxxxxxxxxxx 
  Sent: Monday, October 19, 2009 9:13 AM
  Subject: RE:  French characters


  You may use UTF-8 both in your code and database. It is used more commonly. (almost seems to become a encoding standart)

  -----Original Message-----
  From: Don [mailto:don@xxxxxxxxxxxxx] 
  Sent: Monday, October 19, 2009 4:08 PM
  To: php-general@xxxxxxxxxxxxx
  Subject: Re:  French characters

  I am using the following code:
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />


  "Mert Oztekin" <moztekin@xxxxxxxxxxxxxxxxxxxxx> wrote in message 
  news:E2C046087E10D943811A0BD0A4E8316D1BD2E81C0E@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
  What about browsers encoding? And also, does your html code has a header 
  about character-encoding in french

  -----Original Message-----
  From: Don [mailto:don@xxxxxxxxxxxxx]
  Sent: Monday, October 19, 2009 3:58 PM
  To: php-general@xxxxxxxxxxxxx
  Subject:  French characters

  Hi,

  I use PHP to read data form a mysql 5 table. allow the user to edit the data
  and then update the table.  I am having trouble with French characters.

  Before the update:  Pas de description détaillée
  After the update:    Pas de description détaillée

  When I read from the table I wrap the data in the following:
      // Stripslashes
      if (!get_magic_quotes_gpc()) {
          $value = stripslashes($value);
      }
      // Convert all applicable characters to HTML entities
      $value = htmlentities($value,ENT_COMPAT);

  When I update to the table, I wrap in the following:
      // Addslashes
      if (!(get_magic_quotes_gpc())) {
         $value = addslashes($value);
      }
      // Quote if not a number or a numeric string
      if (!is_numeric($value)) {
         $value = @mysql_real_escape_string($value);
      }

  I've tried playing with character sets to no avail.  There mst be a
  solution,

  Thanks
  Don



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



    ________________________________
  Bu mesaj ve ekleri, mesajda gönderildiði belirtilen kiþi/kiþilere özeldir ve 
  gizlidir. Size yanlýþlýkla ulaþmýþsa lütfen gönderen kisiyi bilgilendiriniz 
  ve mesajý sisteminizden siliniz. Mesaj ve eklerinin içeriði ile ilgili 
  olarak þirketimizin herhangi bir hukuki sorumluluðu bulunmamaktadýr. 
  Þirketimiz mesajýn ve bilgilerinin size deðiþikliðe uðrayarak veya geç 
  ulaþmasýndan, bütünlüðünün ve gizliliðinin korunamamasýndan, virüs 
  içermesinden ve bilgisayar sisteminize verebileceði herhangi bir zarardan 
  sorumlu tutulamaz.

  This message and attachments are confidential and intended for the 
  individual(s) stated in this message. If you received this message in error, 
  please immediately notify the sender and delete it from your system. Our 
  company has no legal responsibility for the contents of the message and its 
  attachments. Our company shall have no liability for any changes or late 
  receiving, loss of integrity and confidentiality, viruses and any damages 
  caused in anyway to your computer system.



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



    ________________________________  
  Bu mesaj ve ekleri, mesajda gönderildigi belirtilen kisi/kisilere özeldir ve gizlidir. Size yanlislikla ulasmissa lütfen gönderen kisiyi bilgilendiriniz ve mesaji sisteminizden siliniz. Mesaj ve eklerinin içerigi ile ilgili olarak sirketimizin herhangi bir hukuki sorumlulugu bulunmamaktadir. Sirketimiz mesajin ve bilgilerinin size degisiklige ugrayarak veya geç ulasmasindan, bütünlügünün ve gizliliginin korunamamasindan, virüs içermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan sorumlu tutulamaz.

  This message and attachments are confidential and intended for the individual(s) stated in this message. If you received this message in error, please immediately notify the sender and delete it from your system. Our company has no legal responsibility for the contents of the message and its attachments. Our company shall have no liability for any changes or late receiving, loss of integrity and confidentiality, viruses and any damages caused in anyway to your computer system.