Has anyone done any unsigned int32 to signed int32 conversion in CF? Actually more accurately, unsigned long (int64) to signed int32 conversion. My problem is, I need the results of a java crc16 calculation stored in a MSSQL int column:

var checksum = createObject( "java", "java.util.zip.CRC32" ).init();
        checksum.update( charsetDecode( input, "utf-8" ) );
        var crc = javaCast("int",checksum.getValue());

crc I need inserted into a sql table:

...
crc:         { value:"#crc#", cfsqltype:"integer" },
...

The problem is, checksum.getValue() returns a long int (signed) because java does not support unsigned int32. But my google expertise is failing me here and I cannot find a simple solution.

Does the discussion here help: https://stackoverflow.com/questions/25556017/how-to-use-the-unsigned-integer-in-java-8-and-java-9