Forums | Mahara Community
Support
/
Diacritic letter problem when adding users via .csv
05 March 2010, 8:45
Hi,
We are running Mahara on this configuration:
Linux v. Redhat server 5 64-bitar
Apache v. 2.2.3
Mahara v. 1.2.3
MySQL v.5.0.77
PHP 5.1.6
I have added 200+ users via a .csv file. The accounts were created. However, the name fields (firstname and lastname) were truncated after diacritical letters. The last name "Björkegren" became "Bj" and the first name "Björn" also became "Bj".
Is there some localization setting that we have missed somewhere?
/Odd
05 March 2010, 13:21
Hi,
greetings from Germany. We use "Umlauts" äöü
Take care to use a utf8 encoded csv file. I hope thats solves your Problem.
Heinz
06 March 2010, 18:28
Hi,Heinz says what is right. If you generated the file with a different encoding of UTF-8 when data is loaded into the database, the words are truncated in those letters that are not encoded as UTF-8 but in another system, usually Windows (iso-8859-1).
Greetings
09 March 2010, 4:54
Thanks to both Heinz and Antonio. Next time a generate users I'll use UTF-8.
/Odd