character sets in .net

25 Feb 2006 3:22 PM

Dror

Hello,
I'm developing a winforms applciation which retrive data using ado.net.
My Database has an WE8ISO8859P1 character set and the data is in hebrew.

My Problem is when I'm trying to retrive the data I get "??????".
When I retrive the same data from a vb6 application using ado
I don't have this problem.

What the cause for this problem and how to fix it ?

thanks.

27 Feb 2006 4:12 PM

Cowboy (Gregory A. Beamer) - MVP

I have tackled this, but do not have a step-by-step. If I remember correctly,
it has to do with the current culture of the running thread. Once the culture
is set, I believe you are fine on the basics. You may also have to set your
stream objects to a particular character set, esp. if you are moving from one
set to another somewhere in the process.

Good luck!

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Show quote

"Dror" wrote:

> Hello,
> I'm developing a winforms applciation which retrive data using ado.net.
> My Database has an WE8ISO8859P1 character set and the data is in hebrew.
>
> My Problem is when I'm trying to retrive the data I get "??????".
> When I retrive the same data from a vb6 application using ado
> I don't have this problem.
>
> What the cause for this problem and how to fix it ?
>
> thanks.