db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5236) Client driver silently truncates strings that exceed 32KB
Date Tue, 17 May 2011 15:54:47 GMT
Client driver silently truncates strings that exceed 32KB
---------------------------------------------------------

                 Key: DERBY-5236
                 URL: https://issues.apache.org/jira/browse/DERBY-5236
             Project: Derby
          Issue Type: Bug
          Components: Network Client
    Affects Versions: 10.8.1.2
            Reporter: Knut Anders Hatlen


Can be seen with this JUnit test case that retrieves a VARCHAR value with 20000 characters.
With the client driver, the string is truncated to 10900 characters (32700 bytes when encoded
in UTF-8).

    public void testLongColumn() throws SQLException {
        PreparedStatement ps = prepareStatement(
                "values cast(? as varchar(20000))");

        char[] chars = new char[20000];
        Arrays.fill(chars, '\u4e10');
        String str = new String(chars);

        ps.setString(1, str);
        JDBC.assertSingleValueResultSet(ps.executeQuery(), str);
    }

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message