Problem with multiple character sets and searching

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

Adding in character sets

Is there a way to add support for additional character sets to an existing mysql installation without recompiling? I am currently running mysql 3.23.32 if I do need to recompile should I get the source for 3.23.32 or should I already upgrade to 3.23.42? Thanks, David Suna [EMAIL PROTECTED] [E

Full text search algorithm

Where can I find a description of the algorithm that mysql uses for weighting results from a full text search? Is there a way to provide some user specified criteria to alter the weighting? (i.e. a callback mechanism) Is there a way to get back the weights assigned to each row returned? Is t