Hi Felipe, Steps;
mysql -u root -p <password> show databases; use pf; show tables; describe person; *To display the current character encoding set for a particular database * *SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "pf";* *ALTER DATABASE DBNAME CHARACTER SET utf8 COLLATE utf8_general_ci; * *To display the current character encoding set for a particular table in a database* *SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "pf" AND T.table_name = "person";* Thanks Cumprimentos, *Domingos Varela* Tel. +244 923 229 330 | Luanda - Angola Felipe Rodrigues via PacketFence-users < [email protected]> escreveu no dia segunda, 15/07/2019 à(s) 07:07: > Hello Fabrice! > > How can I check that? > > I used this command to access the MySQL: mysql -u root -p > > After that I received this message: > > *Welcome to the MariaDB monitor. Commands end with ; or \g.* > > *Your MariaDB connection id is 405* > > *Server version: 10.1.21-MariaDB MariaDB Server* > > > *Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.* > > > *Type 'help;' or '\h' for help. Type '\c' to clear the current input > statement.* > > Is it correct? The version 9.0.1 use MariaDB? Can you help me with the > commands to check the table pf.person? > > Thanks! > > ------------------------------ > *De:* Fabrice Durand via PacketFence-users < > [email protected]> > *Enviado:* sexta-feira, 12 de julho de 2019 15:08 > *Para:* [email protected] > *Cc:* Fabrice Durand > *Assunto:* Re: [PacketFence-users] Orthographic Error - Web Portal > > > Hello Rodrigues, > > can you check in the db to see if the encoding is correct ? (table > pf.person) > > Regards > > Fabrice > > > Le 19-07-11 à 08 h 03, Felipe Rodrigues via PacketFence-users a écrit : > > Any ideia? > > Sent from my iPhone > > On 8 Jul 2019, at 14:52, Felipe Rodrigues <[email protected]> > wrote: > > Hey guys, how are you doing? > > I have a character recognition problem in the portal when the user > authenticates using sponsor: > > <image.png> > > In this case, the correct name was: João Conceição but the Packet Fence > but PacketFence did not identify some characters. I changed the Portal > Language to Portuguese. > > Is there any way I can sort this manually? > > > > _______________________________________________ > PacketFence-users mailing > [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users > > <https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fpacketfence-users&data=02%7C01%7C%7C31cd775b0a1b4a14875b08d706f456a1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636985518805416507&sdata=DlhG9Wyiq2x6zkHI0mxvsHKeiUNz3IItB65bLbOukWE%3D&reserved=0> > > -- > Fabrice [email protected] :: +1.514.447.4918 (x135) :: > www.inverse.ca > <https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.inverse.ca&data=02%7C01%7C%7C31cd775b0a1b4a14875b08d706f456a1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636985518805426517&sdata=3mwBnVjbcgH6o0vJNfaPSMPnAGc2swdNp2Prs3dgKbk%3D&reserved=0> > Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu > <https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sogo.nu&data=02%7C01%7C%7C31cd775b0a1b4a14875b08d706f456a1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636985518805436522&sdata=grBFZp9hk%2F%2Bo81MDdIAB73MBFgni5p4FRgl1Kto1I78%3D&reserved=0>) > and PacketFence (http://packetfence.org > <https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpacketfence.org&data=02%7C01%7C%7C31cd775b0a1b4a14875b08d706f456a1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636985518805446533&sdata=TAJTUKie3%2F6z9eEafUvilSliGzecZcQeIFcNxjesUeM%3D&reserved=0>) > > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users >
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
