Getting Byte[] data with MySQL -Cast(... AS BINARY)

Hi,
>
I am trying to get (and transfer over ASP.NET) some encrypted data
from some MySQL fields. Since the data contains many unicode
characters, I tried to get the data as a series of ASCII values,
transfer those numeric values over ASP.NET. I had no problem doing
this on my local computer, by getting the field with "cast(field as
BINARY)" so that on ASP.NET I have a byte[] array.Then send every
field of array over ASP.Net.
>
However when I upload application to remote server, "cast(field as
BINARY)" returns field data as String type. I have tried many ways to
convert this string data to byte array, however data always become
corrupted. So I have to get data as a byte array directly from MySQL.
>
As I've said, I had no problem doing this on my local computer,
however, on my local computer I was connecting to same computer using
same driver (MySQL Odbc 3.51), so when I upload the ASP.NET page to
remote server, ONLY thing that is changing is location and -maybe-
ASP.NET version (I am sure both are ASP.NET 2 , maybe different
builds)
>
So, the bottom line is: I am trying to get MySQL data as byte[] type,
on local web server I have no problem, on remote web server
(connecting to SAME MySQL Server) I get data as String, instead of
Byte[]. How can I achieve same result on remote server?

First, let's step back. You are using encrypted data, which means you have
char 255. This was a problem in traditional ASP, but should not be a
problem in ASP.NET, as strings are Unicode by default. I have not played
extensively with MySQL, so I cannot be completely sure, but I have done
extensive work with encryption in other databases, requiring no need to pull
as binary.
>
I would try pulling the string out straight rather than running from string
to byte[] and back to Unicode string.
>
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
>
*************************************************
| Think outside the box!
|
*************************************************" ist" <say...@gmail.comwrote in message
>
news:7ed964cd-9a3e-4c64-91f1-c601a2080fde@p73g2000hsd.googlegroups.com...
>
>
>>>>>>
- Alýntýyý göster -

First, let's step back. You are using encrypted data, which means you have
char 255. This was a problem in traditional ASP, but should not be a
problem in ASP.NET, as strings are Unicode by default. I have not played
extensively with MySQL, so I cannot be completely sure, but I have done
extensive work with encryption in other databases, requiring no need to
pull
as binary.
>
I would try pulling the string out straight rather than running from
string
to byte[] and back to Unicode string.
>
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
>
*************************************************
| Think outside the box!
|
*************************************************" ist" <say...@gmail.com>
wrote in message
>
news:7ed964cd-9a3e-4c64-91f1-c601a2080fde@p73g2000hsd.googlegroups.com...
>
>
>>>>>>
- Alýntýyý göster -