mySqlBytes.buff er is getting converted to BigEndian even though both SQL server 2005 and the CLR function are on the same machine which shows BitConverter.Is LittleEndian == true

[DR]

mySqlBytes.buff er is getting converted to BigEndian even though both SQL
server 2005 and the CLR function are on the same machine which shows
BitConverter.Is LittleEndian == true

in tsql: select * from dbo.MY_CLR_FUNC TION(cast(1024 as binary(4)))

public static int MY_CLR_FUNCTION (SqlBytes mySqlBytes)

in debugger binaryData.buff er now shows bigendian!!
[0] 0 byte
[1] 0 byte
[2] 4 byte
[3] 0 byte

the data stays littleendian if the integer is hard coded in C#:

int myint;
myint = 1024;
byte[] b = new byte[4];
b = BitConverter.Ge tBytes(myint);

in debugger binaryData.buff er shows littleendian
[0] 0 byte
[1] 4 byte
[2] 0 byte
[3] 0 byte
in all cases BitConverter.Is LittleEndian shows true, so why is the integer
hard coded in tsql getting converted to big endian when it arrives in a clr
function?

[Stephany Young]

The point is that it is not being converted to any-endian.

binary(4) is nothing more that a buffer of bytes and cast(... as binary(4))
is certainly NOT analogous to BitConverter.Ge tBytes(int).

If you want it correctly then pass the int (intact) to the function and use
BitConverter inside the function.
"DR" <so************ *******@yahoo.c omwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

mySqlBytes.buff er is getting converted to BigEndian even though both SQL
server 2005 and the CLR function are on the same machine which shows
BitConverter.Is LittleEndian == true

in tsql: select * from dbo.MY_CLR_FUNC TION(cast(1024 as binary(4)))

public static int MY_CLR_FUNCTION (SqlBytes mySqlBytes)

in debugger binaryData.buff er now shows bigendian!!
[0] 0 byte
[1] 0 byte
[2] 4 byte
[3] 0 byte

the data stays littleendian if the integer is hard coded in C#:

int myint;
myint = 1024;
byte[] b = new byte[4];
b = BitConverter.Ge tBytes(myint);

in debugger binaryData.buff er shows littleendian
[0] 0 byte
[1] 4 byte
[2] 0 byte
[3] 0 byte
in all cases BitConverter.Is LittleEndian shows true, so why is the integer
hard coded in tsql getting converted to big endian when it arrives in a
clr function?