sonia Posted March 26, 2007 Share Posted March 26, 2007 hi fellows i am working on a project in which i m developing a large urdu database, i m using EasyPHP(PHP4.3.10 and mysql4.1.9).for the database developed in mysql i developed a search module that is working correctly with the data in english language. but when i tried to retrieve records of Urdu language the same module didn't worked for the urdu language. i have searched a lot on internet for this but m not getting any solution to this problem. that the same module which works for english language but not for Urdu however bith PHP and Mysql supports unicoded data.either it returns a blank page or it shows groups of question marks.but not the urdu data. can any of u help me in this regard,i need help in this regard and if anyone can help me i would be highly grateful, ineed a quick responce plzzz. Sonia Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/ Share on other sites More sharing options...
mmarif4u Posted March 26, 2007 Share Posted March 26, 2007 Salam... I think u want it like this, www.geo.tv www.urdupoint.com www.bbcurdu.com etc Am i right Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/#findComment-215203 Share on other sites More sharing options...
sonia Posted March 27, 2007 Author Share Posted March 27, 2007 thanx mmarif4u but all these sites are either in graphics form that is they are not in processable form. but my problem is that ,that i m using php and my sql but the queries qre not retrieving the urdu records. but the same module is working well with english records thia means that the module is working correctly there is some problem with processing urdu if u can help me i ll be grateful. thanx Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/#findComment-215875 Share on other sites More sharing options...
monk.e.boy Posted March 27, 2007 Share Posted March 27, 2007 You may have to change your table data type. I think I had to change my columns from latin1_swedish_ci to utf8_unicode_ci, this now works with tons of odd languages. You also have to change your HTML to include: <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> Now both the database and the browser are configured to utf8 (This is what google uses) and should both store and present utf8 characters. The one thing to note is all the database admin tools I have used are NOT utf8 and if you try to use them to look at or edit any utf8 data it fucks it up big time. Hope that helps. monk.e.boy Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/#findComment-215889 Share on other sites More sharing options...
shunix Posted March 27, 2007 Share Posted March 27, 2007 Here are a few (more) tips, extending that of monkey boy: . Use a PC > Win2K . Install Urdu support for OS (http://www.boriat.com/urduinst/) . Set your page encoding to utf-8 and write urdu as normal english text in html pages . Similarly in db, set your db encoding to utf8 and insert/retrieve text as usual Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/#findComment-215891 Share on other sites More sharing options...
monk.e.boy Posted March 27, 2007 Share Posted March 27, 2007 Check each bit as you do it. So change the database. Now check it is urdu OK. Now write a test HTML page with utf8. Check it works!!! Now link the database to the page (PHP) check it works!!! then put all this back into your normal web pages. Lots and lots of tests!! monk.e.boy Link to comment https://forums.phpfreaks.com/topic/44312-urdu-processing/#findComment-215934 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.