Character error Social Media

filippe_macedo · October 5, 2015, 5:09pm

when we receive an interaction from facebook or/and twitter is not possible to display the message correctly by a problem of character
if we send a message in Spanish “producción”(for example) in the end User screen we see as "producci@“n”

we change the option general.non-unicode-connection-encoding for Workspace Edition but we failed!

the message is received like this from the Social Messaging Server and in UCS as well

any idea?
Thanks

cavagnaro · October 5, 2015, 5:28pm

We had a similar issue on email, problem was db coding. On the server was wrong, Oracle was used. By setting correct environment variables we fixed it

filippe_macedo · October 5, 2015, 6:29pm

the windows environment variables ?

cavagnaro · October 5, 2015, 6:37pm

The ones that control Oracle BD client behavior. If you use Oracle ask your DBA

filippe_macedo · October 6, 2015, 2:50pm

Thanks !

Kubig · October 6, 2015, 2:52pm

You have to check all levels as:

locale environment and variables (especially on Windows platform)
DBMS and DB client used encoding
Application settings