[Gambas-user] MySQL language problems

[Jorge Carrión]

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
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mConexion.class.tar.gz
Type: application/x-gzip
Size: 1096 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20130227/55c56f70/attachment.bin>