6
OK, I see the problem. When should those queries be sent? After opening the connection?
I guess it would not be difficult to add to the MySQLDatabase constructor (Is it really necessary in XoopsDatabaseFactory? Having MySQL-specific queries there seems to make it more difficult for us to create new classes for PostGreSQL or others)
However, this is only for MySQL 4.1 and higher? Do you know how to see the database version without knowing the encoding? I mean, we need to know the database version before we start querying, and we shouldn't set the character set on sub-4.1 versions.
Or perhaps we should have a new class? One for MySQL 4.0.x or lower and one for MySQL 4.1 or higher?
When we get the approach right, I'll do my best to see to it that we get the right solution, too.
Thank you for your help in explaining the problem and finding the solution, Victor.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."
Cusix Software