Skip to Content
0
Former Member
Dec 29, 2014 at 06:27 PM

Charset cp850 Sybase ASE - ADO.NET

774 Views

Hi!

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:

<connectionStrings>

<add name="database" connectionString="Data Source='192.168.0.1';Port='5000';UID='sa';PWD='';Database='test';CharSet='cp850';" />

</connectionStrings>

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