使用JDBC和ODBC将TEXT列插入Informix数据库的一致方法

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class InsertTextColumn {
    public static void main(String[] args) {
        String url = "jdbc:informix-sqli://localhost:9088/mydatabase:INFORMIXSERVER=myserver";
        String user = "myuser";
        String password = "mypassword";
        String sql = "INSERT INTO mytable (textcolumn) VALUES (?)";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             PreparedStatement pstmt = conn.prepareStatement(sql)) {

            pstmt.setString(1, "This is a TEXT column value");
            pstmt.executeUpdate();

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

#include <sql.h>
#include <sqlext.h>
#include<stdio.h>

int main() {
    SQLHENV env;
    SQLHDBC dbc;
    SQLHSTMT stmt;
    SQLRETURN ret;

    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env);
    SQLSetEnvAttr(env, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0);
    SQLAllocHandle(SQL_HANDLE_DBC, env, &dbc);

    SQLCHAR connStr[] = "DRIVER={Informix ODBC Driver};"
                          "SERVER=myserver;"
                          "DATABASE=mydatabase;"
                          "UID=myuser;"
                          "PWD=mypassword;";

    ret = SQLDriverConnect(dbc, NULL, connStr, SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT);

    SQLAllocHandle(SQL_HANDLE_STMT, dbc, &stmt);

    SQLCHAR sql[] = "INSERT INTO mytable (textcolumn) VALUES (?)";
    ret = SQLPrepare(stmt, sql, SQL_NTS);

    SQLCHAR textValue[] = "This is a TEXT column value";
    SQLLEN textLength = SQL_NTS;

    ret = SQLBindParameter(stmt, 1, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_LONGVARCHAR, 0, 0, textValue, 0, &textLength);
    ret = SQLExecute(stmt);

    SQLFreeHandle(SQL_HANDLE_STMT, stmt);
    SQLDisconnect(dbc);
    SQLFreeHandle(SQL_HANDLE_DBC, dbc);
    SQLFreeHandle(SQL_HANDLE_ENV, env);

    return 0;
}