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
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
