will help you You have to tell MYSQL that the communication done is going to be in UTF8 for this to work. The easier is, after your connection to the database, to execute this query : SET NAMES 'utf8' which will, once and until the disconnection, tell mysql that you are going to talk in UTF8.
With these it helps In order to read the UTF-8 file, you'll probably need to use the ADODB.Stream object. I don't claim to be an expert on character encoding, but this test worked for me: test.txt (saved as UTF-8 without BOM):
Const adTypeText = 2
Const adReadLine = -2
Dim stream : Set stream = CreateObject("ADODB.Stream")
stream.Type = adTypeText
stream.Charset = "UTF-8"
Do Until stream.EOS
Convert Chinese characters in Percent-Encoded URI string to Chinese characters in UTF-8?
I hope this helps you . I want to make a Haskell script to read files in my /home folder. However there are many files named with Chinese characters, and Haskell and Ghci cannot manage it. It seems Haskell and Ghci aren't good at displaying UTF-8 characters.
To fix the issue you can do The first problem is that setting the LC_TIME category is not enough by itself. The strftime function will attempt to format the time in the appropriate language, but it seems to use the 1252 codepage by default, so it will be incapable of producing the necessary characters for something like Chinese. I would have expected that setting LC_TIME and maybe LC_CTYPE would be enough, but the only way I could get it to work was with LC_ALL. So your setlocale calls should look like this: