Hi Loick, I solved it!!
Acording this site... http://search.cpan.org/~capttofu/DBD-mysql-4.027/lib/DBD/mysql.pm ...I added the 'mysql_enable_utf8' handle to connection string in file: /usr/local/pf/lib/pf/db.pm (line: 104) So my connection string was as follows: $mydbh = DBI->connect( "dbi:mysql:dbname=$db;host=$host;port=$port", $user, $pass, { RaiseError => 0, PrintError => 0, mysql_enable_utf8 => 1 } ); That's all! Regards, Leonel Bonito ADMINISTRADOR DE REDES Gerencia de Sistemas +54 341 410 3192 - www.citycenter-rosario.com.ar - Bv. Oroño y Av. Circunvalación (S2000DSI) Rosario, SF - Argentina -----Mensaje original----- De: Leonel Bonito [mailto:[email protected]] Enviado el: Miércoles, 16 de Abril de 2014 15:48 Para: [email protected] Asunto: Re: [PacketFence-users] Issues with accents on MySQL Hi Loick, The result is "latin1". If I wanna edit directly on the 'Person' table, I can write accents correctly. Thanks! Regards, Leonel Bonito ADMINISTRADOR DE REDES Gerencia de Sistemas +54 341 410 3192 - www.citycenter-rosario.com.ar - Bv. Oroño y Av. +Circunvalación (S2000DSI) Rosario, SF - Argentina -----Mensaje original----- De: Loick Pelet [mailto:[email protected]] Enviado el: Miércoles, 16 de Abril de 2014 15:30 Para: [email protected] Asunto: Re: [PacketFence-users] Issues with accents on MySQL Hello Leonel, Please send us the result of this SQL statement. SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "pf"; I assume your db is named "pf". I presume you are using the wrong encoding. thanks. Loick On Apr 16-02:56PM, Leonel Bonito wrote: > Hi, > > I'm having a problem with some users who fills their data on Captive Portal > where his first name or last name contain an accent. > > Here an example... > 1- An user fills the first name: 'Gastón', last name: 'Pérez' and go on... > 2- The system send him an email 'Hi Gastón Pérez...' with the activation link. > 3- At same time, the system add him to 'Person' table but this appears with > some symbols. > > This is how appears on MySQL: > firstname | lastname > Gastón | Pérez > > There are something that I can do to fix it? > > Thanks in advance! > > Leonel Iván Bonito > ADMINISTRADOR DE REDES > Gerencia de Sistemas > > [cid:[email protected]] > > +54 341 410 3192 - > +www.citycenter-rosario.com.ar<http://www.citycenter-rosario.com.ar/> > +- Bv. Oroño y Av. Circunvalación (S2000DSI) Rosario, SF - Argentina > ---------------------------------------------------------------------- > -------- Learn Graph Databases - Download FREE O'Reilly Book "Graph > Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, this > first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users -- [email protected] :: +1.514.447.4918 (x130) :: www.inverse.ca<http://www.inverse.ca/> Inverse inc. :: Leaders behind SOGo (www.sogo.nu<http://www.sogo.nu/>) and PacketFence +(www.packetfence.org<http://www.packetfence.org/>) gtalk or skype : lpelet.inverse ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Start Your Social Network Today - Download eXo Platform Build your Enterprise Intranet with eXo Platform Software Java Based Open Source Intranet - Social, Extensible, Cloud Ready Get Started Now And Turn Your Intranet Into A Collaboration Platform http://p.sf.net/sfu/ExoPlatform _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
