I have a table in a mysql database that contains data from two different languages using two different character sets. I need to be able to query in either language. Queries that I run against the data in English seem to run fine. However, queries against the data in the other language give inconsistent results. If the search string has multiple words then the results will contain rows that do not contain the entire search string. I am running the query through PHP. The query is select sourceid, $SearchLanguage from sources where $SearchLanguage like \"%$SearchString%\"
The query runs to completion correctly but returns seemingly invalid results. I am running mysql 3.23.32 on a RedHat Linux 7.0 system. Mysql gets started up on startup via safe_mysqld. I have tried adding default-character-set in my.cnf to set the character set to the other language's character set. I have placed this both in the safe_mysqld section and in the mysql.server section and reindexed the table (using myisamchk -r -q) but that hasn't changed the behavior. I thought that I might have to recompile mysql to support the other character set but from the documentation (section 4.6.1) it seems that all standard binary distributions come with support for additional character sets built in. Any help in sorting out this problem would be appreciated. David Suna [EMAIL PROTECTED] [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php