如何将Oracle中以字符串存储的RAW数据类型转换为Java String？

Hey there! Converting Oracle RAW data to a Java String is a pretty common task, but the exact approach depends on how the original string was encoded when it got stored as RAW. Let me break down the most frequent scenarios with practical code examples.

RAW in Oracle is essentially a byte array, so if your original string was converted to bytes using a standard charset (e.g., UTF-8) before being stored as RAW, you just need to reverse that process by decoding the bytes back into a String with the same charset.

Here’s how you’d do this with JDBC:

// Assume you've executed your query and have a ResultSet
ResultSet rs = yourStatement.executeQuery("SELECT raw_column FROM your_table");
if (rs.next()) {
    // Get the RAW data as a byte array
    byte[] rawBytes = rs.getBytes("raw_column");
    
    // Decode the bytes using the correct charset (adjust to match your storage encoding)
    String convertedString = new String(rawBytes, StandardCharsets.UTF_8);
    
    System.out.println("Converted String: " + convertedString);
}

Pro tip: Make sure the charset you use here matches exactly what was used when the data was inserted into the Oracle table. Using the wrong charset will result in garbled text. Common alternatives to UTF-8 are ISO_8859_1 or US_ASCII.

Sometimes RAW is used to store hexadecimal values (like MD5 hashes or unique IDs) where each character in the original string maps to a byte in the RAW. In this case, you need to convert the byte array to a hexadecimal string.

You can implement this natively without any third-party libraries:

private static String rawToHexString(byte[] rawBytes) {
    StringBuilder hexBuilder = new StringBuilder();
    for (byte b : rawBytes) {
        // Format each byte as two hexadecimal characters (uppercase)
        hexBuilder.append(String.format("%02X", b));
    }
    return hexBuilder.toString();
}

// Usage with your ResultSet
byte[] rawBytes = rs.getBytes("raw_column");
String hexString = rawToHexString(rawBytes);

If you’re already using libraries like Apache Commons Codec or Google Guava, you can simplify this:

• Apache Commons Codec: Hex.encodeHexString(rawBytes)
• Guava: com.google.common.io.BaseEncoding.base16().encode(rawBytes)

If the RAW column in Oracle can be NULL, rs.getBytes() will return null, which will throw a NullPointerException if you try to pass it directly to the String constructor. Always add a check:

byte[] rawBytes = rs.getBytes("raw_column");
String convertedString;

if (rawBytes != null) {
    convertedString = new String(rawBytes, StandardCharsets.UTF_8);
} else {
    // Handle NULL case (e.g., set to empty string or keep as null)
    convertedString = "";
}

Quick recap #

• If the RAW is encoded text: Decode the byte array with the matching charset.
• If the RAW is a hex value: Convert the byte array to a hex string.
• Always handle NULLs to avoid runtime exceptions.

内容的提问来源于stack exchange，提问作者Sumit Sundriyal