YQL html extracted output is garbled

[reedom]

YQL html extractor seems that it doesn't handle any encoding specs in the target document.

Here is a query againt a blog site written in `euc-jp' encoding:

CODE

select * from html 
  where url="http://blog.livedoor.jp/dankogai/" 
  and xpath='//div[contains(concat(" ", @class, " "), " plugin-monthly ")]//a'

The result document contains garbled characters.
Will you fix up it?

[Nagesh Susarla]

YQL html extractor seems that it doesn't handle any encoding specs in the target document.

Here is a query againt a blog site written in `euc-jp' encoding:

CODE

select * from html 
  where url="http://blog.livedoor.jp/dankogai/" 
  and xpath='//div[contains(concat(" ", @class, " "), " plugin-monthly ")]//a'

The result document contains garbled characters.
Will you fix up it?

Hi,

You can use the 'charset' parameter available on the html table to pass in the correct encoding and it should work as desired

CODE

 
select * from html 
where url="http://blog.livedoor.jp/dankogai/" 
and xpath='//div[contains(concat(" ", @class, " "), " plugin-monthly ")]//a' and charset='euc-jp'

-- Nagesh