Discussion:
[PacketFence-devel] Diacritic letters are distroyed
Filip Pohronský
2015-04-07 13:54:09 UTC
Permalink
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 |
Filip Pohronský
2015-04-07 18:30:59 UTC
Permalink
I almost forgot to add I use OVA deployment of packetfence.
Post by Filip Pohronský
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).
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
https://lists.sourceforge.net/lists/listinfo/packetfence-devel
Loading...