I have been trying to search a Hindi page in page.sql table. For this i convert the entered page title to ISO-8859-1 iconv("UTF-8","ISO-8859-1", $search); and is then trying to search in the database no result is shown but i know that the page exist in page.sql table.
Hoi, Why convert to Latin-1? There is no need. Thanks, GeradM
2009/1/26 Ankuj Gupta ankuj2004@gmail.com
I have been trying to search a Hindi page in page.sql table. For this i convert the entered page title to ISO-8859-1 iconv("UTF-8","ISO-8859-1", $search); and is then trying to search in the database no result is shown but i know that the page exist in page.sql table. -- Ankuj _______________________________________________ Wikipedia-l mailing list Wikipedia-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikipedia-l
For eg Select * from page where page_title='インド' is my query. How to execute this query on mysql tables as data is not stored in utf-8 format but the collation of page_title filed is latin_1
Ankuj Gupta wrote:
For eg Select * from page where page_title='インド' is my query. How to execute this query on mysql tables as data is not stored in utf-8 format but the collation of page_title filed is latin_1
Try:
select * from page where page_title=convert('インド' using binary);
You should probably convert the tables from latin1 to binary to avoid future corruption.
-- Tim Starling
wikipedia-l@lists.wikimedia.org