Euro Symbol and other special characters

[philipg...@hotmail.com]

Has anyone ever experienced an issue pulling the Euro symbol with this
driver? I am currently using the .NET 2.0 Sybase drivers, trying to
pull data from a Sybase ASE 12.5.3 database. I end up getting weird
characters back from any field that contains the Euro symbol. I've
tried using the Charset=cp1252; in the connection string to fix this
issue:

data
source=servername;uid=user;pwd=password;port=12345;CharSet=cp1252;

This seems to work in conjuction with the below but only on a view, if
I were to run this on a table I get an exception about the charset.

asecommand1.CommandText="set char_convert off"
asecommand1.ExecuteNonQuery()
asecommand1.CommandText="select blah_Euro_Field FROM db..blah_table
WHERE blah_id=@id"

outputdata=asecommand1.ExecuteReader

Any insight is appreciated.

[Paul Vero [Sybase]]

Hi

What Provider version? If it's sort of old you should consider
upgrading the Provider. I'd have to see the TDS trace to get an idea
of what's going on. The Provider internally works with unicode,
but this should still be okay with what you're doing.

-Paul

<philipg...@hotmail.com> wrote in message
news:1f5dd796-ff6c-41db...@x6g2000vbg.googlegroups.com...

[philipg...@hotmail.com]

I'm using version 1.15.305.0 Sybase.AdoNet2.AseClient.dll

On May 18, 4:14 pm, "Paul Vero [Sybase]" <pv...@nospam.com> wrote:
> Hi
>
> What Provider version?  If it's sort of old you should consider
> upgrading the Provider.  I'd have to see the TDS trace to get an idea
> of what's going on.  The Provider internally works with unicode,
> but this should still be okay with what you're doing.
>
> -Paul
>

> <philipgrossm...@hotmail.com> wrote in message

[Paul Vero [Sybase]]

Hi,

I'm not sure if this is known or not.

Could you try this connection property:

KeepOrgMultibyte=1

It's a special un-documented property for handling certain, unique
conversion situations. If it doesn't work, try the latest ESD#18 - with
same option. If that doesn't work, please log tech support case
with Sybase.

What charset does your ASE use?

-Paul

<philipg...@hotmail.com> wrote in message
news:036bc712-748d-41c7...@n21g2000vba.googlegroups.com...

[philipg...@hotmail.com]

KeepOrgMultibyte=1 worked! That's unfortunate that it is not
documented anywhere. I tried it without that property and it gave the
garbage character, I tried it with the character and I get the Euro
Symbol. I'll have to test this further but so far so good.

Thanks for the help!

On May 19, 10:07 am, "Paul Vero [Sybase]" <pv...@nospam.com> wrote:
> Hi,
>
> I'm not sure if this is known or not.
>
> Could you try this connection property:
>
> KeepOrgMultibyte=1
>
> It's a special un-documented property for handling certain, unique
> conversion situations.  If it doesn't work, try the latest ESD#18 - with
> same option.  If that doesn't work, please log tech support case
> with Sybase.
>
> What charset does your ASE use?
>
> -Paul
>