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.
Special characters imports as a question mark (?)
-
- Posts: 7565
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Special characters imports as a question mark (?)
Your CSV import file needs to be converted to UTF-8 encoding first
Aware IM Support Team
-
- Posts: 2431
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Special characters imports as a question mark (?)
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Special characters imports as a question mark (?)
Higuys
Thank you very much. I will give it a try and let you know. Thanks again.
Thank you very much. I will give it a try and let you know. Thanks again.
Re: Special characters imports as a question mark (?)
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
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
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Re: Special characters imports as a question mark (?)
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
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42
Re: Special characters imports as a question mark (?)
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
Forum discussion
http://www.awareim.com/forum/viewtopic.php?t=5284
Instructions
https://github.com/RennurApps/AwareIM-r ... #databases
Re: Special characters imports as a question mark (?)
thank you for your suggestion.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
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
George
________________________________
Developer Edition
AwareIM: v8.5, build 2824
OS: Windows Server 2012
DB: MySql 5.6.42