Special characters imports as a question mark (?)

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Special characters imports as a question mark (?)

Post by karelh »

Hi,

I am not sure if I am the only getting this strange error. When import information into business objects from CSV files it automatically changes any special characters to questions marks. ie. è Is this related to the DB (MySQL) or AwareIM?

I found a similar article from 2006 but it was resolved years ago. Did it perhaps resurface?
https://www.awareim.com/forum/viewtopic.php?f=2&t=582

I am using Developer Edition Ver. 8.1 Build 2453 with MySQL.

Please let me know if I can provide more detail or if there is perhaps a setting I should look at.
aware_support
Posts: 7565
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: Special characters imports as a question mark (?)

Post by aware_support »

Your CSV import file needs to be converted to UTF-8 encoding first
Aware IM Support Team
customaware
Posts: 2431
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Special characters imports as a question mark (?)

Post by customaware »

And you need to ensure UTF8 is turned on in MySQL
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
karelh
Posts: 86
Joined: Wed Oct 26, 2016 10:20 pm

Re: Special characters imports as a question mark (?)

Post by karelh »

Higuys

Thank you very much. I will give it a try and let you know. Thanks again.
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Special characters imports as a question mark (?)

Post by weblike »

I also have this problem, but with json. My java plugin imports text in DB from a webservice with these kind of strange characters.
the DB is UTF-8 ...
I'm using v7.1 build 2238
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Special characters imports as a question mark (?)

Post by weblike »

Also tested in latest build 2455 on separate server, separate Mysql ->same result.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Rennur
Posts: 1191
Joined: Thu Mar 01, 2012 5:13 am
Location: Sydney, Australia

Re: Special characters imports as a question mark (?)

Post by Rennur »

You may need to manually update Connector/J.

Forum discussion
http://www.awareim.com/forum/viewtopic.php?t=5284

Instructions
https://github.com/RennurApps/AwareIM-r ... #databases
weblike
Posts: 1165
Joined: Sun Dec 02, 2012 12:00 pm
Location: Europe

Re: Special characters imports as a question mark (?)

Post by weblike »

Rennur wrote:You may need to manually update Connector/J.

Forum discussion
http://www.awareim.com/forum/viewtopic.php?t=5284

Instructions
https://github.com/RennurApps/AwareIM-r ... #databases
thank you for your suggestion.
I have replaced with the latest Connector/J, but unfortunately for me is not working... the diacritics are not showing well.
Thx,
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Post Reply