I almost forgot to add I use OVA deployment of packetfence.
Dňa 7.4.2015 o 15:54, Filip Pohronský <fi...@pohronsky.sk> napísal:
> Dear devels,
> I deal with captive portal registraton and table pf.person collation.
> Our national language use diacritics.
> When user use Slovak diacritics letters (like á,í,é,š,č), the packetfence
> will store that in ureadable format (latin1).
>
> What I successfully did:
> I changed the pf.person table to latin2, which support diacritics.
> I successfully store diacritics latin2 letters.
> But admin portal show corrupted letters.
>
> What should I change inside packetfence to display correct letters?
> I will appreciate any help move me fwd, when pf admin portal show right
> letters with diacritics.
>
> Kind regards,
> Filip
>
>
> <Snímka obrazovky 2015-03-19 o 12.13.32.png>
>
>
> mysql> SHOW CREATE TABLE person;
> | person | CREATE TABLE `person` (
> `pid` varchar(255) CHARACTER SET latin1 NOT NULL,
> `firstname` varchar(255) DEFAULT NULL,
> `lastname` varchar(255) DEFAULT NULL,
> `email` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `telephone` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `company` varchar(255) DEFAULT NULL,
> `address` varchar(255) DEFAULT NULL,
> `notes` varchar(255) DEFAULT NULL,
> `sponsor` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `anniversary` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `birthday` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `gender` char(1) CHARACTER SET latin1 DEFAULT NULL,
> `lang` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `nickname` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `cell_phone` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `work_phone` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `title` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `building_number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `apartment_number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `room_number` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_1` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_2` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_3` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_4` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_5` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_6` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_7` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_8` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `custom_field_9` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `portal` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> `source` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
> PRIMARY KEY (`pid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin2 |
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF_______________________________________________
> PacketFence-devel mailing list
> PacketFence-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-devel
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-devel mailing list
PacketFence-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
