MySQL Forums
Forum List  »  PHP

Having tough time with spanish/catalan characters in my PHP/MySQL app
Posted by: Raj Tsevhar
Date: February 08, 2009 07:10AM

Hi,

I have some problem with special characters in my pages which I am using PHP and MySQL.

When we insert data with some Catalan special characters (à é è í ï ó ò ú ü ç) that data is storing in data base like below

>Actual content: Bar restaurant La Cuspinedaú

>Database storing content: Bar restaurant La Cuspinedaú

While displaying that content special characters not coming

>Displayed content: Bar restaurant La Cuspinedaú

If i insert data with special characters directly with PHPMyadmin special characters are inserting properly.
But if i use PHP-MySQL function "mysql_query()" to execute a query the special characters are inserting like this "ú".

I am using table charset encoding as "latin1" and the field collation is 'latin1_swedish_ci' .

And the data is coming from HTML form and that charset encoding is 'iso-8859-1'.

Recently we had changed the content(files and DB) from old server to new server. After changing to new server we are getting this problem.



Is this PHP or MySQL configuration settings problem?

Please help me regarding this.

Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
Having tough time with spanish/catalan characters in my PHP/MySQL app
February 08, 2009 07:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.