Categories
Categories:   All Categories
Suggested keywords
x
New
 Issue

Special characters replaced by ? in iCal import

JEvents (Free Access)
  JEvents (Free Access)
vuegoguan
  vuegoguan
  Wednesday, 27 September 2017
  6 Replies
  1K Visits
0
Votes
Undo
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
Support Info
Production - Medium
Oldest First  
geraint
geraint
Friday, 29 September 2017 13:04
·
#193910
Accepted Answer
0
Votes
Undo
Your file is not encoded as UTF-8 - try this version
tonyp
tonyp
Wednesday, 27 September 2017 09:30
·
#193767
0
Votes
Undo
Hello,

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

Many thanks
Tony
vuegoguan
vuegoguan
Wednesday, 27 September 2017 09:51
·
#193777
0
Votes
Undo
It is the collation utf8_general_ci...
tonyp
tonyp
Wednesday, 27 September 2017 23:56
·
#193821
0
Votes
Undo
If you write the text into the import event description and save is it still formatted as you input it?
vuegoguan
vuegoguan
Thursday, 28 September 2017 08:41
·
#193823
0
Votes
Undo
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...
geraint
geraint
Friday, 29 September 2017 13:04
·
#193910
Accepted Answer
0
Votes
Undo
Your file is not encoded as UTF-8 - try this version
vuegoguan
vuegoguan
Friday, 29 September 2017 14:41
·
#193912
0
Votes
Undo
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
  • Page :
  • 1
There are no replies made for this post yet.