[PHP] issue with accents and mysql

2005-02-15 Thread mario
Hello, please help me on the following issue. please reply to [EMAIL PROTECTED] too. (I asked for help on the php-db ml, but nobody replied) I have hacked the following function: function accents($text) { global $export; $search = array ( 'à', 'è', 'ì', 'ò' , 'ù'); $replace = array (

Re: [PHP] issue with accents and mysql

2005-02-15 Thread Guillermo Rauch
Try SHOW VARIABLES LIKE 'character_set%' and verify your character set is latin1. If not, see http://dev.mysql.com/doc/mysql/en/charset-database.html On Tue, 15 Feb 2005 22:04:30 +, mario [EMAIL PROTECTED] wrote: Hello, please help me on the following issue. please reply to [EMAIL

Re: [PHP] issue with accents and mysql

2005-02-15 Thread mario
Hi, thanks, but that seems to be ok: SQL result Host: 127.0.0.1 Database : Generation Time: Feb 15, 2005 at 11:36 PM Generated by: phpMyAdmin 2.5.7-pl1 / MySQL 3.23.58 SQL-query: SHOW VARIABLES LIKE 'character_set%'; Rows: 2 Variable_name Value character_set

Re: [PHP] issue with accents and mysql

2005-02-15 Thread Bret Hughes
On Tue, 2005-02-15 at 17:40, mario wrote: Hi, thanks, but that seems to be ok: SQL result Host: 127.0.0.1 Database : Generation Time: Feb 15, 2005 at 11:36 PM Generated by: phpMyAdmin 2.5.7-pl1 / MySQL 3.23.58 SQL-query: SHOW VARIABLES LIKE 'character_set%'; Rows: 2

Re: [PHP] issue with accents and mysql

2005-02-15 Thread Burhan Khalid
mario wrote: Hello, please help me on the following issue. please reply to [EMAIL PROTECTED] too. (I asked for help on the php-db ml, but nobody replied) I have hacked the following function: function accents($text) { global $export; $search = array ( 'à', 'è', 'ì', 'ò' , 'ù'); $replace