Skip to Content
avatar image
Former Member

Charset cp850 Sybase ASE - ADO.NET

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 29, 2014 at 06:57 PM

    Hi,

    So are you developing this on Windows 2012 or a different version of Windows? What version of the Sybase.AdoNet#.AseClient.dll are you using? I am assuming your ASE's default charset is CP850? What language is the ASE set to?

    Please give us this information I think you might be hitting a known issue. If it is the issue than you might try to set the charset=iso_1.

    Thanks,
    Dawn Kim

    Add comment
    10|10000 characters needed characters exceeded