> I don't know what the spec says.
> But when you think this should be the correct behaviour than there
> probably is a bug in the driver, because i got the following

I tried the following code, but it works:

PreparedStatement stmt = connection.prepareStatement(
"INSERT INTO test_table VALUES (1, ?)");

stmt.setString(1, "WERT");
stmt.setString(1, "");
int updated = stmt.executeUpdate();
System.out.println("Inserted " + updated + " rows");

table definition is:

CREATE TABLE test_table(
id INTEGER,
"F_KH_EINHEIT_SOLL" VARCHAR(15) CHARACTER SET WIN1252
);

connection is in auto-commit mode.

Can you show your code?

Thanks!
Roman Rokytskyy