Le 11/04/2013 12:36, Jorge Carrión a écrit : > A few weeks ago I post a comment about a bug in gb-db-mysql (I guess) about > the loosing of language preferences after de time-out close connection of > mysql server. The solution aparently was to increase the time-out in the > server but, if the time-out is too big, then my application hangs after a > unindetermined amount of time... > I back to decrease the time-out of server and the application doesn't hangs > any more... but the language preferences are loosed again. > I've read somewhere that this bug have been fixed in 3.4.0 version of > Gambas3, but I've installed de 3.4.1 of the Nemh Repositories and the bug > is not fixed. > What can I do? I'm Spanish and all my databases are in UTF-8 general... my > clients are very angry with me... help, please. > > Thanks in advance > > Regards
Each time a mysql database connection is opened, a "set names utf8" command is sent to the mysql server. If your connection is closed by the server, then you should get an error on the client at the next command. Then, either you abort the application, either you manage the error by opening the connection again. Then, the "set names utf8" is emitted again, so I don't understand how the "language preferences" could be lost. So please be give more details of what you call "language preferences". Or better create a little project example with a little database that allows me to reproduce your problem on my computer. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user