Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 96913 invoked from network); 7 Nov 2005 10:59:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Nov 2005 10:59:01 -0000 Received: (qmail 13418 invoked by uid 500); 7 Nov 2005 10:58:59 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 13396 invoked by uid 500); 7 Nov 2005 10:58:59 -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 13385 invoked by uid 99); 7 Nov 2005 10:58:58 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Nov 2005 02:58:58 -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.144] (HELO e4.ny.us.ibm.com) (32.97.182.144) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Nov 2005 02:58:52 -0800 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e4.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id jA7AwYFZ001622 for ; Mon, 7 Nov 2005 05:58:34 -0500 Received: from d01av02.pok.ibm.com (d01av02.pok.ibm.com [9.56.224.216]) by d01relay04.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id jA7AwY4A086996 for ; Mon, 7 Nov 2005 05:58:34 -0500 Received: from d01av02.pok.ibm.com (loopback [127.0.0.1]) by d01av02.pok.ibm.com (8.12.11/8.13.3) with ESMTP id jA7AwYlv026603 for ; Mon, 7 Nov 2005 05:58:34 -0500 Received: from [127.0.0.1] (sig-9-48-117-114.mts.ibm.com [9.48.117.114]) by d01av02.pok.ibm.com (8.12.11/8.12.11) with ESMTP id jA7AwRsC026503 for ; Mon, 7 Nov 2005 05:58:31 -0500 Message-ID: <436F332D.9040705@debrunners.com> Date: Mon, 07 Nov 2005 02:57:49 -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> In-Reply-To: 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 Knut Anders Hatlen wrote: > Legolas Woodland writes: > > >>Hi >>Does derby support inserting unicode data into its char variant fields ? >>for example inserting Arabic ? >>in sqlServer there is Ntext and nchar ,nvarchar ... to support unicode data. >>in mysql there are charset and collat + some connection url parameter that make using unicode data possible >>now how i can use unicode inderby ? >>i tried to use but it does not shows correct data , it replace them with ??? All character types in Derby are stored in Unicode, that is, the character set is always Unicode. When you say 'it does not shows correct data', what exactly is 'it'. The Derby engine is a JDBC driver, thus all of its interactions are through Java code which of course supports Unicode. The Derby engine, itself, does not 'show data', the application calling Derby shows the data, thus the application may not be encoding the data its receives from Derby correctly. The ij tool has some options to provide encoding in its output, this may be useful: http://db.apache.org/derby/docs/dev/tools/rtoolsijpropref97949.html > What's your locale? I think Derby gets problems with unicode when > LC_ALL (or LC_CTYPE) is invalid. Are there Jira entries for these problems? I'm not sure what could be going on, because Derby's use of Unicode is through Java and independent of any local setting (at least for the engine). Dan.