I am trying to get some data from internet and insert it into MySQL
database. However, since the data coming from internet is Encoded
(with MySQL's encode function), it has many many non-standart
characters (and the data type of field is UTF-8) I have tried to get
data from internet with TWebBrowser, and inserted it with Zeos.
However, I could not accomplish.
My generated web document is in UTF8 encoding (I can confirm this via
TWebBrowser's Document.charset property) however when I read the page
source with WebBrowser1.Document AS IHTMLDocument2).body.innerText
property, I can see some characters are already corrupted (even
innerText is WideString) so I cannot 'know' whether I will have
problem with the following steps (split data into fields, feed it into
Zeos SQL Query etc.)
Does anybody have any suggestions about that process?