Skip navigation
megharajdeepak
megharajdeepak
Currently Being Moderated

Passing flex byteArray to .NET MS SQL

Jul 4, 2012 4:34 AM

Tags: #flex #.net #bytearray #sql #ms #byte[]

Hello there,

I'm trying to pass an encoded image as byteArray to .NET backend. The .NET method uses byte[] as datatype to accept byteArray from flex. Flex byteArray variable is fine until it reaches the webservice, it's total lenth is 1540. But when it tries to insert to DB table, it truncates the data and saves only first 256 characters!!

 

Am I missing something? If yes, it would be great if someone can let me know the right to to save byteArray datatype into MS SQL DB via webservice.

 

Appreciate your help..

 

Cheers!

Deepak

429 Views   2 Replies   Latest reply: megharajdeepak, Jul 5, 2012 10:34 PM
 
Replies
  • DotNETDev
    Currently Being Moderated
    1. DotNETDev,
    Jul 5, 2012 9:54 PM   in reply to megharajdeepak
    Report

    Being a .NET guy myself, judging from what you've posted, it sounds like you've got something messed up with your SQL data type, probably in your table or stored procedure.

     

    From what you're saying, it sounds like the byteArray is fine from the Flex side of things, correct? You're passing it into a web service (at which point, its fine), but then once it leaves the web service for your database, its getting messed up in the SQL INSERT statement?    

     
    |
    Mark as:
  • megharajdeepak
    Currently Being Moderated
    2. megharajdeepak,
    Jul 5, 2012 10:34 PM   in reply to DotNETDev
    Report

    Well, eventually the byte data was getting saved properly and completely in DB. But when I ran the query in console, unfortunately it was just showing first 256 characters! And I kept thinking that it's saving only so much in DB

     

    When I passed this data back from DB to flex, I did got what I had passed earlier and I was able to recreate the image out of it

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points