Special characters imports as a question mark (?)

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?
Import and special characters>

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

Your CSV import file needs to be converted to UTF-8 encoding first

customaware

And you need to ensure UTF8 is turned on in MySQL

karelh

Higuys

Thank you very much. I will give it a try and let you know. Thanks again.

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

weblike

Also tested in latest build 2455 on separate server, separate Mysql ->same result.

Rennur

You may need to manually update Connector/J.

Forum discussion

weblike

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

Forum discussion