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]> wrote:
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. For example, it takes the values specified by the user for first name and last name and queries the table for rows that match the first_name and last_name columns. When I run the query on the PHP page the result is that no rows are found. When I print out the SQL that was run and copy and paste it into a query on phpMyAdmin against the same database it does return rows in the result set. Does someone know the magic necessary to make the query work when it is run via PHP? Alternatively, how can I debug this problem where the printed SQL works when run through phpMyAdmin but not when run directly? Thanks, -- David Suna [EMAIL PROTECTED] ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]