[Gambas-user] MySQL language problems

[Ron]

If you have access to mysql conf you can also extend the timeout value 
of the server

Change wait_timeout parameter value to prevent database connection lost.
Add this to the [mysqld] section of the config file

$ sudo vi /etc/mysql/my.conf
wait_timeout            = 2147483

$ sudo /etc/init.d/mysql restart

Regards,
Ron.
> Well... with Gambas2 I have the problem that my Mysql server, cut by
> time-out the conexions after a few minutes of no activities. The users
> complains that, so, y develop this module that re-open the connection if
> there is an error.
> Usually I call the functions inside passing a sql string like "select *
> from mytable" etc. Never a complicated sql sentence.
> I can't see nothing wrong. In fact work fine in Gambas2.
> (Writing this post I realize thar I don't know if that question (cuts by
> time-out) are still a problem in Gambas3)...
>
> Any suggestion will be appreciate.
>
> Regards
>
>
> 2013/2/27 Fabien Bodard <gambas.fr at ...626...>
>
>> It look like a quote problem
>> Le 26 févr. 2013 22:09, "M. Cs." <mohareve at ...626...> a écrit :
>>
>>> What kind of syntax are you using to communicate with the database? Give
>> us
>>> some example, please.
>>>
>>> Csaba
>>>
>>> 2013/2/26 Jorge Carrión <shordi at ...626...>
>>>
>>>> I have a serious problem with mysql server. I'm developing a proyect in
>>>> gambas 3.4 on linuxmint 13 maya against a Mysql 5.0.96 server.
>>>>
>>>> All works fine but randomly all characters non english (á é í ñ, etc
>> I'm
>>>> spanish) are miss interpreted. You can work half hour with application
>>>> without problem at all and suddenly all gridview lists an all fields
>> are
>>>> wrong.
>>>>
>>>> Reset de program and some times all runs fine again, some times wrong
>>>> characters are recorded in database.
>>>>
>>>> The collate of Mysql is utf8-general-ci and the charset is
>> ut8-general-ci
>>>> too.
>>>>
>>>> I can't isolate the error...
>>>>
>>>> Any suggest?
>>>>
>>>> Regards
>>>>
>>>>
>> ------------------------------------------------------------------------------
>>>> Everyone hates slow websites. So do we.
>>>> Make your web apps faster with AppDynamics
>>>> Download AppDynamics Lite for free today:
>>>> http://p.sf.net/sfu/appdyn_d2d_feb
>>>> _______________________________________________
>>>> Gambas-user mailing list
>>>> Gambas-user at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>>
>>>
>> ------------------------------------------------------------------------------
>>> Everyone hates slow websites. So do we.
>>> Make your web apps faster with AppDynamics
>>> Download AppDynamics Lite for free today:
>>> http://p.sf.net/sfu/appdyn_d2d_feb
>>> _______________________________________________
>>> Gambas-user mailing list
>>> Gambas-user at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>
>> ------------------------------------------------------------------------------
>> Everyone hates slow websites. So do we.
>> Make your web apps faster with AppDynamics
>> Download AppDynamics Lite for free today:
>> http://p.sf.net/sfu/appdyn_d2d_feb
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Everyone hates slow websites. So do we.
>> Make your web apps faster with AppDynamics
>> Download AppDynamics Lite for free today:
>> http://p.sf.net/sfu/appdyn_d2d_feb
>>
>>
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user