Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Sat, 2 Jul 2011 14:15:28 +0000 (UTC)
From: "Knut Anders Hatlen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1670048005.10665.1309616128661.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1801196890.19500.1305647687503.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (DERBY-5236) Client driver silently truncates
 strings that exceed 32KB
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-5236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13059027#comment-13059027 ] 

Knut Anders Hatlen commented on DERBY-5236:
-------------------------------------------

Right, I only did a quick search for how length was represented various places, and I haven't yet done any research into what's the relevant definition for the length field in this particular method. One example I found was in V4, vol 2, p 48:

Field Length
    format: signed binary integer
    units: characters for DBCS; else bytes
    value:
        0 - 32767 for SBCS and mixed SBCS/DBCS
        0 - 16383 for DBCS

I believe SBCS is single-byte character set and DBCS is double-byte character set. Now, UTF-8 is a variable-width encoding and therefore neither SBCS nor DBCS, strictly speaking.

> 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
>            Assignee: Knut Anders Hatlen
>         Attachments: repro.diff, write-full-string.diff
>
>
> 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