Arabic text in mysql
Hi, I have a database for storing company data for various print catalogues. Now we have a requirement to get Arabic information from companies as well. Hence, the company data table should now contain Arabic text along with the English. To achieve that I first converted the table from latin1 to UTF8 (utf8_general_ci). Then I changed the charcter set on my web pages containing the update forms to UTF-8. Now, the arabic data entered using the webpages is displayed fine in the resultant php pages, but when we want to see the same data in mysql (using mysql query browser/SQL yog/EMS Mysql Manager) the data shows up in binary form or . I fail to understand how can I view Arabic text as it is in a mysql query window, so that when I epxort data it comes as it is and does not come in form of special characters. Have tried searching the net but no solutions have worked so far. Kindly advise. Best regards Hitendra --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Arabic text in mysql
On 5/8/07, shadow [EMAIL PROTECTED] wrote: Have tried searching the net but no solutions have worked so far. Definitely not a CakePHP question. C'mon people, this is not a MySQL support forum. Nor is it a PHP support forum. It's a CakePHP support forum. Don't flame me, because you know I'm right. -- Chris Hartjes My motto for 2007: Just build it, damnit! @TheBallpark - http://www.littlehart.net/attheballpark @TheKeyboard - http://www.littlehart.net/atthekeyboard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Arabic text in mysql
Not sure if that will help, but have you also set utf8 in your db config? var $default = array( 'driver' = 'mysql', 'connect' = 'mysql_connect', 'host' = 'bla', 'login' = 'bla', 'password' = 'bla', 'database' = 'bla', 'prefix' = '', 'encoding' = 'UTF8' ); I believe this only works in 1.2. In 1.1 you need to set the encoding manually (in some before... action in the appModel). --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Cake PHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---