From ddlutils-user-return-358-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Thu Apr 27 23:00:06 2006 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 69823 invoked from network); 27 Apr 2006 23:00:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 27 Apr 2006 23:00:05 -0000 Received: (qmail 63082 invoked by uid 500); 27 Apr 2006 23:00:05 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 63006 invoked by uid 500); 27 Apr 2006 23:00:05 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 62995 invoked by uid 99); 27 Apr 2006 23:00:05 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Apr 2006 16:00:05 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of allanjunli@gmail.com designates 64.233.184.226 as permitted sender) Received: from [64.233.184.226] (HELO wproxy.gmail.com) (64.233.184.226) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Apr 2006 16:00:04 -0700 Received: by wproxy.gmail.com with SMTP id 50so1686628wri for ; Thu, 27 Apr 2006 15:59:43 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=cJ25CMWcGKIja+avopFHDtfi3r9DvQfZS0I2XpEWhId+iKQmodN6XVnQlPa3Vd9PpO5oida0qsUUqSnDtC0fOx4KPco/LPicsqBElhSMU58imNjA3FE4s1er20L+h+2JjhpFnERqlJbnR6YoroFMOp2uZctwFrIDBPOb83Nk6Js= Received: by 10.65.241.1 with SMTP id t1mr51718qbr; Thu, 27 Apr 2006 15:59:43 -0700 (PDT) Received: by 10.65.121.8 with HTTP; Thu, 27 Apr 2006 15:59:43 -0700 (PDT) Message-ID: Date: Fri, 28 Apr 2006 08:59:43 +1000 From: "Jun Li" To: ddlutils-user@db.apache.org Subject: Re: Report varchar for nvarchar on SQL Server. In-Reply-To: <224f32340604271233k5ead1c15oeba55a87bbf93dbd@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_19450_30517672.1146178783844" References: <224f32340604271233k5ead1c15oeba55a87bbf93dbd@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_19450_30517672.1146178783844 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Why don't you simply mapping varchar into nvarchar? It's just about storage space. On 4/28/06, Thomas Dudziak wrote: > > On 4/26/06, Jun Li wrote: > > Yes, well, currently DdlUtils does not support Unicode vs. Non-Unicode > directly (i.e. via a property). And since you also cannot currently > override type mappings, using Unicode is somewhat hard on Oracle or > SQL Server. > For the latter you might perhaps get away by changing the codepage: > > SELECT COLLATIONPROPERTY('Latin1_General_CI_AI', 'CodePage') > > Tom > -- -------------- Cheers, Jun ------=_Part_19450_30517672.1146178783844--