Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 39642 invoked from network); 8 Nov 2005 09:18:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 8 Nov 2005 09:18:52 -0000 Received: (qmail 90794 invoked by uid 500); 8 Nov 2005 09:18:50 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 90766 invoked by uid 500); 8 Nov 2005 09:18:50 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 90754 invoked by uid 99); 8 Nov 2005 09:18:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Nov 2005 01:18:50 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.145] (HELO e5.ny.us.ibm.com) (32.97.182.145) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Nov 2005 01:18:43 -0800 Received: from d01relay02.pok.ibm.com (d01relay02.pok.ibm.com [9.56.227.234]) by e5.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id jA89IMuW006946 for ; Tue, 8 Nov 2005 04:18:22 -0500 Received: from d01av01.pok.ibm.com (d01av01.pok.ibm.com [9.56.224.215]) by d01relay02.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id jA89IMMf102914 for ; Tue, 8 Nov 2005 04:18:22 -0500 Received: from d01av01.pok.ibm.com (loopback [127.0.0.1]) by d01av01.pok.ibm.com (8.12.11/8.13.3) with ESMTP id jA89IMKk031574 for ; Tue, 8 Nov 2005 04:18:22 -0500 Received: from [127.0.0.1] (sig-9-48-126-35.mts.ibm.com [9.48.126.35]) by d01av01.pok.ibm.com (8.12.11/8.12.11) with ESMTP id jA89IF1a031354 for ; Tue, 8 Nov 2005 04:18:20 -0500 Message-ID: <43706D54.50106@debrunners.com> Date: Tue, 08 Nov 2005 01:18:12 -0800 From: Daniel John Debrunner User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: How to use Unicode with derby ? does it supports unicode text ? References: <87ee9b170511060430h19113f47n28a5edda9f6f2cac@mail.gmail.com> <436F332D.9040705@debrunners.com> <1131439685.20959.80.camel@pc977.sb.statsbiblioteket.dk> In-Reply-To: <1131439685.20959.80.camel@pc977.sb.statsbiblioteket.dk> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Lars Clausen wrote: > On Mon, 2005-11-07 at 14:21, Knut Anders Hatlen wrote: > We had an issue recently where we stored into a CLOB using > setCharacterStream but read from it using getAsciiStream, and that did > break the non-ASCII characters (no big surprise). Well, yes for getAsciiStream, though I would not say it breaks anything, but by design it does convert unicode characters outside the range 0x00-0x00 to 0x3f, the question mark character (?). :-) See http://db.apache.org/derby/papers/JDBCImplementation.html#GetAsciiStream%28%29 Dan.