Special characters replaced by ? in iCal import
By Guest on Wednesday, 27 September 2017
Posted in JEvents (Free Access)
Replies 6
Likes 1
Views 0.9K
Votes 0
When i import events from an iCal file, all the special characters (ë, é, è etc.) are replaced by a question mark (?)...

In the iCal file the characters are OK...

Is there a solution for this?

Thanks in advance for the reply
Your file is not encoded as UTF-8 - try this version
Guest
·
Friday, 29 September 2017 13:04
·
1 Likes
·
0 Votes
·
0 Comments
·
Hello,

Can you check what the database collation is for the JEvents tables? it should be utf8_general

Many thanks
Tony
Guest
·
Wednesday, 27 September 2017 09:30
·
1 Likes
·
0 Votes
·
0 Comments
·
It is the collation utf8_general_ci...
Guest
·
Wednesday, 27 September 2017 09:51
·
1 Likes
·
0 Votes
·
0 Comments
·
If you write the text into the import event description and save is it still formatted as you input it?
Guest
·
Wednesday, 27 September 2017 23:56
·
1 Likes
·
0 Votes
·
0 Comments
·
I'm sorry, but i don't understand what you mean by 'write the text into the import event description'. If i change the description of the imported event manually and save it, it is saved just fine, including the special characters. It only goes wrong with the iCal import...
Guest
·
Thursday, 28 September 2017 08:41
·
1 Likes
·
0 Votes
·
0 Comments
·
With this file it works fine!!! I will have a look at the macro which creates the file from Excel...

Thanks for your help!!!

Best regards,

Brand-Jan
Guest
·
Friday, 29 September 2017 14:41
·
1 Likes
·
0 Votes
·
0 Comments
·
View Full Post