getBytes Method (int) (SQLServerResultSet)

Article
11/18/2022

Retrieves the value of the designated column index in the current row of this SQLServerResultSet object as a byte array in the Java programming language.

Syntax

  
public byte[] getBytes(int columnIndex)

Parameters

columnIndex

An int that indicates the column index.

Return Value

An array of byte values.

Exceptions

SQLServerException

Remarks

This getBytes method is specified by the getBytes method in the java.sql.ResultSet interface.

This method supports retrieving all columns as a raw read of bytes from the server. It returns an array of bytes directly from the server, in the format that is stored on the server.

In a previous version of the Microsoft JDBC Driver for SQL Server, you could use SQLServerResultSet.getBytes to convert values between byte arrays and SQL Server data type date, time, datetime2, or datetimeoffset. Now, using this method with those data types will cause an exception indicating that the conversion is not supported.