Re: Database collation
Posted by: Dadvid Dev
Date: June 18, 2013 06:12AM

Dear Rick James

Thanks for your valuable information I have found on your link.

It clarified me a lot of things regarding encoding issue.

Now, and As I tried a lot of search and also try to fix the problem, I did not find the expected result.

What I have and What I am expecting?

What I have:
1- Mysql 5.5.20
2- My database: INNODB latin1 -- cp1252 West European
3- My entries: Mixed Latin (Arabic) characters in varchar, long text varaiables.
4- latin1 -- cp1252 West European is the database default.
5- Header of PHP pages used for insertion: header('Content-Type:text/html; charset=windows-1256');
6- I did NOT use: mysql_set_charset('utf8'); after My connection to the server.

What I expect after database conversion
1-UTF-8 database that accepts arabic chars + accents + ...
2-My new php pages will have the following header: header('Content-Type:text/html; charset=utf-8');
3-Data should be well displayed after conversion
4-New data must be inserted and treated correctly.

I have tried a lot of conversion method, Some of them keeps Data displayed well in the database but are displayed as strange letters in browser.

Could you please assist based on these information?

Thanks a lot for your help and assistance.

Options: ReplyQuote


Subject
Written By
Posted
June 15, 2013 03:13AM
June 16, 2013 11:16AM
Re: Database collation
June 18, 2013 06:12AM


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.