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