Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 11

[Jiayou Hu]

Eugeniy Lugovoy:
Yes, "sprintf_s" and "sprintf" do not support Chinese. I'll try to help you to solve this problem!

Thanks!

[350668368]

Why not output text can supply chinese.

[350668368]

if (!MySqlExecute(DB,"SET CHARACTER_SET_RESULTS=utf8")) 
   {
    // Showing an error message
   }
...

Database still can not OUTPUT Chinese data

[Pavel Kolchin]

mql5_x64 downloaded last

2016.10.14 23:31:18.688 unresolved import function call

2016.10.14 23:31:18.688 Cannot call 'cMySqlConnect', '..\libraries\MQLMySQL.dll' is not loaded

2016.10.14 23:31:18.687 Cannot load 'C:\MetaTrader\MT5 demo\MQL5\libraries\MQLMySQL.dll'.

[Yuriy Asaulenko]

The article is not bad. It's a pity that I don't use MySQL. I use either Access or MS SQL, which is included with VS.

By the way, Access is available on almost any computer. Connecting to Access provides portability without additional software settings and customisations. Sometimes it is important.

[Pavel Kolchin]

I took the trouble to "check out of the box" - it doesn't work.

[Yuriy Asaulenko]

Andrey Khatimlianskii:
It hasn't been licensed or installed automatically with the rest of office for a long time. Why should it be on every computer?

Thanks, I didn't know. I have 2007, it's automatic. And most people still have 2007 or even 2003, imho. Let's learn MySQL).

[Maxim Kuznetsov]

Yuriy Asaulenko:
Thanks, I didn't know. I have 2007, it's automatic. And most people still have 2007 or even 2003, imho. Let's learn MySQL).

SQLite is more reasonable - it doesn't require a separate server, MQ has some plans for it, that's two :-)

PS/ every time I update my laptop (Home ed. may be because of this) some pieces of the registry related to MySQL Community Server are demolished - I have to run its "updater" manually to get everything back in place

[Yuriy Asaulenko]

Maxim Kuznetsov:

SQLite is more reasonable - it doesn't require a separate server - one, MQ has some plans for it - two :-)

PS/ every time I upgrade my laptop (Home ed. may be because of this) some pieces of the registry related to MySQL Community Server - I have to run its "updater" by hand to put everything back in its place.

Looked https://sqlite.org/ Yes, interesting, but all command-line, in a simple way, as even in MS SQL you can't look. For applications there is no difference, but for home use it is inconvenient.

[Maxim Kuznetsov]

Yuriy Asaulenko:
Looked at https://sqlite.org/ Yes, interesting, but everything is simple, as you can't even look into MS SQL. No difference for applications, but for home use it is inconvenient.

There are a lot of third-party GUIs/IDEs for it - and sqlite itself is just a pure database engine and API for embedding it in applications....