I am developing an asp.net mvc application that connects to Sybase. The data in the database are in Spanish, with accents and character 'ñ'. When I retrieve data through ado.net connection, these characters are not interpreted correctly. The connection to the database is:
<add name="database" connectionString="Data Source='192.168.0.1';Port='5000';UID='sa';PWD='';Database='test';CharSet='cp850';" />
It is assumed that the charset that I use is cp850. The database by default uses this charset.
I have read that a user has used the connection parameter KeepOrgMultibyte=1, but does not work me.
Thank you for you help