[prev in list] [next in list] [prev in thread] [next in thread] 

List:       wikipedia-l
Subject:    Re: [Wikipedia-l] Characterset Conversion
From:       Tim Starling <tstarling () wikimedia ! org>
Date:       2009-01-27 0:01:42
Message-ID: gllit6$m6e$1 () ger ! gmane ! org
[Download RAW message or body]

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 mailing list
Wikipedia-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikipedia-l

[prev in list] [next in list] [prev in thread] [next in thread]