Re: [tlug] unable to create local copy utf8 encoded JapaneseMySQLdata

[David Riggs <dariggs@example.com>]

The html entities can be converted in emacs/mule-ucs with Turnbull's 
twister:

(defun entities-to-characters ()
    (interactive)
    (goto-char (point-min))
    (while (re-search-forward "&#\\([a-fA-F0-9]+\\);" nil t)
      (message (match-string 1))
      (insert (or (ucs-to-char (string-to-number (match-string 1) 10))
                  (match-string 0))) ; fail-safe
      (delete-region (match-beginning 0) (match-end 0))))

Caution-- it does the entire file.

David Riggs

(with thanks to the creator Steven T)