Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <16122341.post@talk.nabble.com>
Date: Tue, 18 Mar 2008 08:19:57 -0700 (PDT)
From: Lolas <lohonya@dconstans.hu>
To: derby-user@db.apache.org
Subject: Re: Order by clause with national character set
In-Reply-To: <wjo8lk5h2lb1.fsf@khepri41.norway.sun.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
References: <000001c872ec$c5635990$6c02a8c0@dconstans>
 <wjo8lk5h2lb1.fsf@khepri41.norway.sun.com>


Hello Knut!
Thanks for your answer, it was very hepfully. I beg your pardon for this
late answer, I haven't known that I made this thread. I have registered jus=
t
now.
LL


Knut Anders Hatlen wrote:
>=20
> Lohonya L=C3=A1szl=C3=B3 <lohonya@dconstans.hu> writes:
>=20
>> Hi,
>> =20
>> I want to use a SQL statement with ORDER BY clause along with VARCHAR
>> elements in which there are some national character (=C3=A1,=C3=81, =C5=
=B1,=C5=B0, etc). Our
>> (Hungarian)alphabet is: aA, =C3=A1=C3=81, bB, cC, ...=20
>> How do I setup my Derby database to make these arrangements properly?
>=20
> Hi,
>=20
> It sounds like you need territory-based collation. Take a look at these
> pages in Derby Developer's Guide:
>=20
> http://db.apache.org/derby/docs/10.3/devguide/tdevdvlpcollation.html
> http://db.apache.org/derby/docs/10.3/devguide/cdevcollation.html
>=20
> Here's a small example:
>=20
> ij version 10.4
> ij> connect
> 'jdbc:derby:MagyarDB;create=3Dtrue;territory=3Dhu_HU;collation=3DTERRITOR=
Y_BASED';
> ij> create table t (x varchar(10));
> 0 rows inserted/updated/deleted
> ij> insert into t values 'aA', '=C3=A1=C3=81', 'bB', 'cC', 'a=C3=A1', '=
=C3=A1a';
> 6 rows inserted/updated/deleted
> ij> select * from t order by x;
> X        =20
> ----------
> aA       =20
> a=C3=A1       =20
> =C3=A1a       =20
> =C3=A1=C3=81       =20
> bB       =20
> cC       =20
>=20
> 6 rows selected
>=20
>=20
> Hope this helps,
> --=20
> Knut Anders
>=20
>=20

--=20
View this message in context: http://www.nabble.com/Order-by-clause-with-na=
tional-character-set-tp15565292p16122341.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.