SQL Connect


if I set:
db.SQLExecute(“set names utf8”)

in my database request, it does not return any values on windows, but it does on my Mac. If I comment this line out, my Mac app crashes but the windows version is working.

Any suggestions?

Is that MySQL or Microsoft SQL Server?

Because that line is usually used for MySQL as far as I remember.

It’s a MySQL Server.

I use this for MySQL:

tempSQLDatabaseMBS.ExecuteSQL("SET NAMES utf8 COLLATE utf8_general_ci")

ah, case insensitive compare. That may be useful.