title: JDBC ODBC and 4D Database : when reading a row, the first space character of a column is not sent
body: <p>I use a remote 4D v11 database and an ODBC 4D Driver on Windows to access and read the data.
  The issue is about some rows of a table: these rows have columns beginning with a space character. It's intended.</p>
  
  <p>My java application has to retrieve these columns with their first space character. But it doesn't work.</p>
  
  <p>The ODBC 4D driver works fine. Testing it using Microsoft Query in Excel, reading the
  table the columns have their first space character.</p>
  
  <p>In my java program, i use the JDBC ODBC Driver (jdk 1.7.0_51).
  The open(), Statement, execute() and ResultSet instructions or classes are standard JDBC.
  Unfortunately, the first space character is never retrieved when reading.</p>
  
  <p>The column is seen as CLOB:</p>
  
  <pre><code>int myColumnWithFirstSpace = 5;
  ResultSetMetaData rsmd = rs.getMetaData();
  String type = rsmd.getColumnTypeName(myColumnWithFirstSpace );
  System.out.println(type); // print CLOB
  </code></pre>
  
  <p>The only class supported is String:</p>
  
  <pre><code>String text= rs.getString(myColumnWithFirstSpace);
  // other types return "Operation not yet supported"
  System.out.println(text); // print the content of the column
  </code></pre>
  
  <p>And unfortunately no first space character in the printed text.
  Where can be the error?
  Thanks!</p>