From owner-freebsd-database@FreeBSD.ORG Sun Dec 16 20:05:02 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C296316A41A for ; Sun, 16 Dec 2007 20:05:02 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 6E42F13C501 for ; Sun, 16 Dec 2007 20:05:02 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1J3zGR-0006NG-8N for freebsd-database@freebsd.org; Sun, 16 Dec 2007 19:35:03 +0000 Received: from 81.210.227.230 ([81.210.227.230]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 16 Dec 2007 19:35:03 +0000 Received: from saper by 81.210.227.230 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 16 Dec 2007 19:35:03 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Marcin Cieslak Date: Sun, 16 Dec 2007 20:27:15 +0100 Lines: 17 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 81.210.227.230 User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.8.1.11) Gecko/20071215 SeaMonkey/1.1.7 In-Reply-To: Sender: news Cc: freebsd-ports@freebsd.org, freebsd-java@freebsd.org Subject: Re: Oracle SQL Developer X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 16 Dec 2007 20:05:02 -0000 martinko wrote: > Hallo, > > Would someone care to port Oracle's SQL Developer to FreeBSD, please ? > > > > > Many thanks in advance! There is actually nothing to port, just download the non-JRE platform independent zip file, unpack and run "bash sqldeveloper" from sqldeveloper/sqldeveloper/bin directory. Works for me (7.0-BETA3 on amd64, self-compiled sun jdk15 from ports). --Marcin From owner-freebsd-database@FreeBSD.ORG Tue Dec 18 23:55:10 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 906E816A417 for ; Tue, 18 Dec 2007 23:55:10 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 3B27413C458 for ; Tue, 18 Dec 2007 23:55:10 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1J4mH8-0004d8-Jz for freebsd-database@freebsd.org; Tue, 18 Dec 2007 23:55:02 +0000 Received: from r5j156.net.upc.cz ([86.49.9.156]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 18 Dec 2007 23:55:02 +0000 Received: from gamato by r5j156.net.upc.cz with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 18 Dec 2007 23:55:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: martinko Date: Sun, 16 Dec 2007 13:58:41 +0100 Lines: 9 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: r5j156.net.upc.cz User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8.1.11) Gecko/20071204 SeaMonkey/1.1.7 Sender: news Cc: freebsd-ports@freebsd.org, freebsd-java@freebsd.org Subject: Oracle SQL Developer X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Dec 2007 23:55:10 -0000 Hallo, Would someone care to port Oracle's SQL Developer to FreeBSD, please ? Many thanks in advance! Martin From owner-freebsd-database@FreeBSD.ORG Wed Dec 19 20:42:42 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id CF13816A41B for ; Wed, 19 Dec 2007 20:42:42 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: from istanbul.enderunix.org (freefall.marmara.edu.tr [193.140.143.23]) by mx1.freebsd.org (Postfix) with ESMTP id 094E613C461 for ; Wed, 19 Dec 2007 20:42:41 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: (qmail 89273 invoked by uid 1040); 19 Dec 2007 20:15:02 -0000 Received: from unknown (HELO ISMAIL) (ismail@127.0.0.1) by 0 with ESMTPA; 19 Dec 2007 20:15:00 -0000 Date: Wed, 19 Dec 2007 22:14:24 +0200 From: Ismail YENIGUL X-Mailer: The Bat! (v3.99.3) Professional Organization: EnderUNIX X-Priority: 3 (Normal) Message-ID: <1605513356.20071219221424@EnderUNIX.org> To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1254 Content-Transfer-Encoding: quoted-printable X-SMTP-Filter: SurGATE SMTP Filter Engine Release 1.0.1 http://www.endersys.com X-SurGATE-Result: Clean (Content eval: -4.40 points) Cc: freebsd-questions@freebsd.org Subject: Turkish character sorting on PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Ismail YENIGUL List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Dec 2007 20:42:42 -0000 Hello, I am using PostgreSQL 8.2.5 on FreeBSD 6.2. But I have a problem with sorting Turkish characters. They are listed after "z" character. I initialized the PostgreSQL with the following values: initdb -E UNICODE --locale=3Dtr_TR.UTF-8 and initdb -E LATIN5 --locale tr_TR.ISO8859-9 But the result is like the following: SELECT * from test order by name; "id";"name" 1;"aa" 3;"dd" 6;"mm" 5;"zz" 2;"=E7=E7" 4;"=FE" There is no problem on Linux with the same data. How can I solve this problem? Thanks. =20 --=20 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + http://www.enderunix.org/ismail http://www.endersys.com.tr + + EnderUNIX SDT @ Tr Endersys Consultancy Ltd. + + ismail ~ enderunix.org ismail.yenigul ~ endersys.com.tr + + Volunteer, Core Team Member Project Manager + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ From owner-freebsd-database@FreeBSD.ORG Thu Dec 20 10:45:00 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id C2EA416A468 for ; Thu, 20 Dec 2007 10:45:00 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 7EE0813C442 for ; Thu, 20 Dec 2007 10:45:00 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1J5ItS-00082M-Bh for freebsd-database@freebsd.org; Thu, 20 Dec 2007 10:44:46 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Dec 2007 10:44:46 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Dec 2007 10:44:46 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Thu, 20 Dec 2007 11:44:34 +0100 Lines: 40 Message-ID: References: <1605513356.20071219221424@EnderUNIX.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig2D5D61E373CCE333278A2402" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.6 (X11/20070801) In-Reply-To: <1605513356.20071219221424@EnderUNIX.org> X-Enigmail-Version: 0.95.3 Sender: news Cc: freebsd-questions@freebsd.org Subject: Re: Turkish character sorting on PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Dec 2007 10:45:00 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2D5D61E373CCE333278A2402 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Ismail YENIGUL wrote: > Hello, >=20 > I am using PostgreSQL 8.2.5 on FreeBSD 6.2. But I have a problem with > sorting Turkish characters. They are listed after "z" character. > I initialized the PostgreSQL with the following values: >=20 > initdb -E UNICODE --locale=3Dtr_TR.UTF-8 and Unicode (UTF-8) collations (sorting) don't work on FreeBSD. You can use PostgreSQL 8.1 and the "ICU" patch for it. > initdb -E LATIN5 --locale tr_TR.ISO8859-9 This could work, if the locale is properly defined in the system locale database. Try creating a small C program that sorts your strings using strcoll() to verify this - if the small C program works, it's a PostgreSQL problem. --------------enig2D5D61E373CCE333278A2402 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHakeSldnAQVacBcgRAqLdAJ9D9V4jzyqrZprh2bZkLz3A8rZqwgCdF28G uXG1sG3Ell5APk953LdgcaU= =8VQB -----END PGP SIGNATURE----- --------------enig2D5D61E373CCE333278A2402-- From owner-freebsd-database@FreeBSD.ORG Sat Dec 22 17:09:28 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9BB1416A417 for ; Sat, 22 Dec 2007 17:09:28 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: from istanbul.enderunix.org (freefall.marmara.edu.tr [193.140.143.23]) by mx1.freebsd.org (Postfix) with ESMTP id 9072D13C45A for ; Sat, 22 Dec 2007 17:09:26 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: (qmail 90363 invoked by uid 1040); 22 Dec 2007 17:09:48 -0000 Received: from unknown (HELO ISMAIL) (ismail@127.0.0.1) by 0 with ESMTPA; 22 Dec 2007 17:09:46 -0000 Date: Sat, 22 Dec 2007 19:09:10 +0200 From: Ismail YENIGUL X-Mailer: The Bat! (v3.99.3) Professional Organization: EnderUNIX X-Priority: 3 (Normal) Message-ID: <879443695.20071222190910@EnderUNIX.org> To: Ivan Voras In-Reply-To: References: <1605513356.20071219221424@EnderUNIX.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-SMTP-Filter: SurGATE SMTP Filter Engine Release 1.0.1 http://www.endersys.com X-SurGATE-Result: Clean (Content eval: -4.40 points) Cc: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Subject: Re[2]: Turkish character sorting on PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Ismail YENIGUL List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 22 Dec 2007 17:09:28 -0000 Hello Ivan, Here is the test result. It seems that the problem is on FreeBSD (6.2) . Because =C3=B6 and =C5=9F are before then z in Turkish alphabet. # cat a.c #include int main() { setlocale(LC_COLLATE, "tr_TR.ISO8859-9"); printf("%d\n",strcoll("=C3=B6", "z")); printf("%d\n",strcoll("=C3=BC", "z")); } ftpfreebsd[~]# ./a 124 130 ftpfreebsd[~]#=20 By the way, LC_COLLATE is link to the ../la_LN.US-ASCII/LC_COLLATE in /usr/share/locale/tr_TR.ISO8859-9 directory. Does this mean that LC_COLLATE is missing for tr_TR.ISO8859-9 ? # ls -al /usr/share/locale/tr_TR.ISO8859-9/ total 14 drwxr-xr-x 2 root wheel 512 Jul 9 15:32 . drwxr-xr-x 157 root wheel 4096 Dec 4 2006 .. lrwxr-xr-x 1 root wheel 28 Jul 9 15:32 LC_COLLATE -> ../la_LN.US-AS= CII/LC_COLLATE lrwxr-xr-x 1 root wheel 26 Jul 9 15:32 LC_CTYPE -> ../la_LN.US-ASCI= I/LC_CTYPE -r--r--r-- 1 root wheel 18 Jul 9 15:32 LC_MESSAGES -r--r--r-- 1 root wheel 34 Jul 9 15:32 LC_MONETARY -r--r--r-- 1 root wheel 8 Jul 9 15:32 LC_NUMERIC -r--r--r-- 1 root wheel 352 Jul 9 15:32 LC_TIME and there is no file spesicific to the tr_TR.ISO8859-9 in /usr/src/share= /colldef/ # ls /usr/src/share/colldef/ Makefile el_GR.ISO8859-7.src la_LN.ISO8859-15.src map= .ISO8859-1 ru_RU.CP1251.src README en_DK.example la_LN.ISO8859-2.src map= .ISO8859-13 ru_RU.CP866.src be_BY.CP1131.src es_ES.ISO8859-1.src la_LN.ISO8859-4.src map= .ISO8859-15 ru_RU.ISO8859-5.src be_BY.CP1251.src es_ES.ISO8859-15.src la_LN.US-ASCII.src map= .ISO8859-2 ru_RU.KOI8-R.src be_BY.ISO8859-5.src et_EE.ISO8859-15.src lt_LT.ISO8859-13.src map= .ISO8859-4 sl_SI.ISO8859-2.src bg_BG.CP1251.src hi_IN.ISCII-DEV.src lt_LT.ISO8859-4.src map= .ISO8859-5 sr_YU.ISO8859-5.src ca_ES.ISO8859-1.src hy_AM.ARMSCII-8.src map.ARMSCII-8 map= .ISO8859-7 sv_SE.ISO8859-1.src ca_ES.ISO8859-15.src is_IS.ISO8859-1.src map.CP1131 map= .KOI8-R sv_SE.ISO8859-15.src cs_CZ.ISO8859-2.src is_IS.ISO8859-15.src map.CP1251 map= .KOI8-U uk_UA.CP1251.src de_DE.ISO8859-1.src kk_KZ.PT154.src map.CP866 map= .PT154 uk_UA.ISO8859-5.src de_DE.ISO8859-15.src la_LN.ISO8859-1.src map.ISCII-DEV pl_= PL.ISO8859-2.src uk_UA.KOI8-U.src Thursday, December 20, 2007, 12:44:34 PM, you wrote: > Ismail YENIGUL wrote: >> Hello, >>=20 >> I am using PostgreSQL 8.2.5 on FreeBSD 6.2. But I have a problem with >> sorting Turkish characters. They are listed after "z" character. >> I initialized the PostgreSQL with the following values: >>=20 >> initdb -E UNICODE --locale=3Dtr_TR.UTF-8 and > Unicode (UTF-8) collations (sorting) don't work on FreeBSD. You can use > PostgreSQL 8.1 and the "ICU" patch for it. >> initdb -E LATIN5 --locale tr_TR.ISO8859-9 > This could work, if the locale is properly defined in the system locale > database. Try creating a small C program that sorts your strings using > strcoll() to verify this - if the small C program works, it's a > PostgreSQL problem. --=20 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + http://www.enderunix.org/ismail http://www.endersys.com.tr + + EnderUNIX SDT @ Tr Endersys Consultancy Ltd. + + ismail ~ enderunix.org ismail.yenigul ~ endersys.com.tr + + Volunteer, Core Team Member Project Manager + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ TCP/IP ve A=C4=9F g=C3=BCvenli=C4=9Fi kitab=C4=B1n=C4=B1n 2. bask=C4=B1s=C4= =B1 =C3=A7=C4=B1kt=C4=B1! http://dukkan.acikakademi.com From owner-freebsd-database@FreeBSD.ORG Sat Dec 22 23:03:19 2007 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 85C4E16A420 for ; Sat, 22 Dec 2007 23:03:19 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.185]) by mx1.freebsd.org (Postfix) with ESMTP id D530213C447 for ; Sat, 22 Dec 2007 23:03:18 +0000 (UTC) (envelope-from ivoras@gmail.com) Received: by rv-out-0910.google.com with SMTP id l15so1231535rvb.43 for ; Sat, 22 Dec 2007 15:03:18 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; bh=UHjjO60IoK6Yo6oNaznIuqZVOKa3R1UIEBsBoVkeMuU=; b=FRbyUk4kc+Q/bOXzJLiu+Y0dSmDUIDkhbrzjwvugfBGQ/Kq96fjnfy7Nhtsy7M9LjsTVo8XFSup1cUxFIlSDWPIWjEuOkXe7a3btQII/ie+NxdRORhswB+srpfWRV7I6IprYBxk8CPh0cAwo8M8kVJiJxs4uQD6BT06jJDclx1o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=g2bfpBLe8C5ee9mGnJu7xI/Zv5I8SfOnh+Hso3jWCPtmF0xaDn1Pkgup9mWCPaPJdAhKV7De2kAufb+TW6DvVg1jTbR0ymXkfiwISJROwJgxdbz2QMTh8TMY1Yd9U9zlP0khzekYGaPyJxR9m+8lzf1K5U3OzUrx9fknQrWBXo4= Received: by 10.141.33.21 with SMTP id l21mr1601684rvj.140.1198362908899; Sat, 22 Dec 2007 14:35:08 -0800 (PST) Received: by 10.141.212.1 with HTTP; Sat, 22 Dec 2007 14:35:08 -0800 (PST) Message-ID: <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com> Date: Sat, 22 Dec 2007 23:35:08 +0100 From: "Ivan Voras" Sender: ivoras@gmail.com To: "Ismail YENIGUL" In-Reply-To: <879443695.20071222190910@EnderUNIX.org> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1605513356.20071219221424@EnderUNIX.org> <879443695.20071222190910@EnderUNIX.org> X-Google-Sender-Auth: 0d99abbdd4bf5daf Cc: freebsd-database@freebsd.org, freebsd-questions@freebsd.org Subject: Re: Re[2]: Turkish character sorting on PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 22 Dec 2007 23:03:19 -0000 On 22/12/2007, Ismail YENIGUL wrote: > By the way, LC_COLLATE is link to the ../la_LN.US-ASCII/LC_COLLATE > in /usr/share/locale/tr_TR.ISO8859-9 directory. Does this mean that > LC_COLLATE is missing for tr_TR.ISO8859-9 ? Yes.