Re: French characters

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@lists.php.net Sent: Monday, October 19, 2009 9:13 AM Subject: RE: [PHP] 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@program-it.ca] Sent: Monday, October 19, 2009 4:08 PM To: php-general@lists.php.net Subject: Re: [PHP] French characters I am using the following code: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> "Mert Oztekin" <moztekin@anadolusigorta.com.tr> wrote in message news:E2C046087E10D943811A0BD0A4E8316D1BD2E81C0E@ankara.anadolusigorta.pvt.... What about browsers encoding? And also, does your html code has a header about character-encoding in french -----Original Message----- From: Don [mailto:don@program-it.ca] Sent: Monday, October 19, 2009 3:58 PM To: php-general@lists.php.net Subject: [PHP] 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.