Maxxim,

Not sure if you tried this, but have you tried using Convert.ToBase64String?

HTH.

Cheers,

Peter

http://entropia-online.blogspot.com/

Thanks Peter...

Really I don't remember if I tried this... (I think i tried all except the right solution)
The problem here it's because if the string don't be in the right way the insert will be corrupted and the iserted binary will have other value completely different!

Now I moved to others problems and i don't have my solution ready to try this but when I have i'll try and write here the result!

Maxxim,

I camr across that bit of code while googling to see if I could find sometghing specific to help you out. But like you said, a lot of pages did mention that if any truncation would occur, or any slight manipulation of the string, the "new" binary would be radically different.

I know how you feel though. I've had countless times where I was very close to a solution, and then started trying out various things, only to find out i most likely did try the proper solution, but not with the right amount of parameters or something like that :)

Just out of curiosity, are you trying to export BLOBs, or is the problem the default binary data stored in the profile table?

Peter

http://entropia-online.blogspot.com/

My first problem was import BLOBs.

In version 1 I had my password field in blob!
I tried to make this same script, without sucess!
But I used a sqlprocedure to solve my problem!

First I generated all inserts by asp.net
Second I call this sql procedure and made an "update line for each userPassword"
And it worked for me in version 1!

But now, the generated aspnet tables has a couple of binary/Image/gui/etc fields!
It's hard to use the same solution!
But I don't want to loose more time with this! If someone cames here and tell me how can I convert a datareader with profile binary to string: GREAT!! If nobody appears I'll use the wizard!

Thanks for the help