This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi guys :-) I might be missing something here so feel free to put me right but this was just something I spotted: I have a byte[], I chuck it in a varbinary field in a Sql 2005 database and then pull it back out (all through lightspeed of course). If I look at the byte[] its not really what I put in. If I go: Encoding.UTF8.GetString(byteArrayReturnedFromLightSpeed) I get the kind of string you would see in Sql Management studio, that is, 0x..... If I strip the 0x off the string and then spit the hex values through: byte.Parse(encodedString.Substring(i, 2), System.Globalization.NumberStyles.HexNumber)); in a loop that gives me back my original byte[]. Would it be possible for LightSpeed to not return the "0x..." string as a byte[] but do this conversion and push back out what was fed into the db automatically under the hood? Cheers, James |
|