Re: PHP, MySQL, Hebrew question

2007-05-10 Thread Gadi Cohen
Your input and stored data need to agree in character set. Make sure either that you are displaying the page to the user in a hebrew character set (so that input will be sent back in same charset) or as was already suggested, switch everything over to utf8. You can do this either by using

Re: PHP, MySQL, Hebrew question

2007-05-10 Thread Ilya Konstantinov
You've chosen a ISO-8859-8 (logical or visual play no role here) encoding for the MySQL tables. Do you know which encoding your PHP pages accept the form data in? (And why for heaven's sake somebody developing an app in 2007 doesn't use UTF-8 everywhere?) On 5/10/07, David Suna <[EMAIL PROTECTED]

PHP, MySQL, Hebrew question

2007-05-10 Thread David Suna
While this is not directly linux related it is FOSS related. I have a MySQL 5 database that has fields with Hebrew values. The fields are defined as varchar with a hebrew_general_ci collation. I have a PHP page that takes values specified in a form field and runs a query against the table.