From owner-freebsd-database@FreeBSD.ORG Sun Dec 23 14:41:29 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 C1F6816A420 for ; Sun, 23 Dec 2007 14:41:29 +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 E3DBA13C4EE for ; Sun, 23 Dec 2007 14:41:28 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: (qmail 26291 invoked by uid 1040); 23 Dec 2007 14:41:52 -0000 Received: from unknown (HELO ISMAIL) (ismail@127.0.0.1) by 0 with ESMTPA; 23 Dec 2007 14:41:51 -0000 Date: Sun, 23 Dec 2007 16:41:14 +0200 From: Ismail YENIGUL X-Mailer: The Bat! (v3.99.3) Professional Organization: EnderUNIX X-Priority: 3 (Normal) Message-ID: <892749461.20071223164114@EnderUNIX.org> To: "Ivan Voras" In-Reply-To: <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com> References: <1605513356.20071219221424@EnderUNIX.org> <879443695.20071222190910@EnderUNIX.org> <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com> 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[4]: 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: Sun, 23 Dec 2007 14:41:29 -0000 Hello, I am volunteer for this issue. But, I don't know how to create a locale Can someone give me hints(url, howto etc) about this issue? Thanks in advance. Sunday, December 23, 2007, 12:35:08 AM, you wrote: > 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. > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" --=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 Sun Dec 23 20:47:49 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 0F64616A419 for ; Sun, 23 Dec 2007 20:47:49 +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 4D95313C448 for ; Sun, 23 Dec 2007 20:47:48 +0000 (UTC) (envelope-from ismail@EnderUNIX.org) Received: (qmail 36573 invoked by uid 1040); 23 Dec 2007 20:40:51 -0000 Received: from unknown (HELO ISMAIL) (ismail@127.0.0.1) by 0 with ESMTPA; 23 Dec 2007 20:40:49 -0000 Date: Sun, 23 Dec 2007 22:40:12 +0200 From: Ismail YENIGUL X-Mailer: The Bat! (v3.99.3) Professional Organization: EnderUNIX X-Priority: 3 (Normal) Message-ID: <1601099540.20071223224012@EnderUNIX.org> To: "Ivan Voras" In-Reply-To: <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com> References: <1605513356.20071219221424@EnderUNIX.org> <879443695.20071222190910@EnderUNIX.org> <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed;boundary="----------5AF21BB1FFA4DC7" 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[4]: 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: Sun, 23 Dec 2007 20:47:49 -0000 ------------5AF21BB1FFA4DC7 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello, I think, I managed to give full Turkish locale support by modifying /usr/src/share/colldef/la_LN.ISO8859-1.src file. I made some tests, It is working fine. I will submit a new PR. Also please find the attached patch for the people who want to test it. Sunday, December 23, 2007, 12:35:08 AM, you wrote: > 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. > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" --=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 ------------5AF21BB1FFA4DC7 Content-Type: application/octet-stream; name="tr_TR.ISO8859-9.diff" Content-transfer-encoding: base64 Content-Disposition: attachment; filename="tr_TR.ISO8859-9.diff" ZGlmZiAtcnVOIC91c3Ivc3JjL3NoYXJlL2NvbGxkZWYub3JpZy9NYWtlZmlsZSAvdXNyL3Ny Yy9zaGFyZS9jb2xsZGVmL01ha2VmaWxlCi0tLSAvdXNyL3NyYy9zaGFyZS9jb2xsZGVmLm9y aWcvTWFrZWZpbGUJU3VuIERlYyAyMyAyMjozNjowMiAyMDA3CisrKyAvdXNyL3NyYy9zaGFy ZS9jb2xsZGVmL01ha2VmaWxlCVN1biBEZWMgMjMgMjI6MzU6NDIgMjAwNwpAQCAtMzQsNiAr MzQsNyBAQAogCQlzcl9ZVS5JU084ODU5LTUgXAogCQlzdl9TRS5JU084ODU5LTEgXAogCQlz dl9TRS5JU084ODU5LTE1IFwKKwkJdHJfVFIuSVNPODg1OS05IFwKIAkJdWtfVUEuQ1AxMjUx IFwKIAkJdWtfVUEuSVNPODg1OS01IFwKIAkJdWtfVUEuS09JOC1VCkBAIC03OSw3ICs4MCw2 IEBACiBVUy1BU0NJSV9HQjE4MDMwPSBsYV9MTjp6aF9DTgogVVMtQVNDSUlfR0IyMzEyPSBs YV9MTjp6aF9DTgogVVMtQVNDSUlfR0JLPQlsYV9MTjp6aF9DTgotVVMtQVNDSUlfSVNPODg1 OS05PSBsYV9MTjp0cl9UUgogVVMtQVNDSUlfU0pJUz0JbGFfTE46amFfSlAKIAogQVNDSUlM SU5LUz0JZW5fQVUgZW5fQ0EgZW5fR0IgZW5fTlogZW5fVVMKZGlmZiAtcnVOIC91c3Ivc3Jj L3NoYXJlL2NvbGxkZWYub3JpZy90cl9UUi5JU084ODU5LTkuc3JjIC91c3Ivc3JjL3NoYXJl L2NvbGxkZWYvdHJfVFIuSVNPODg1OS05LnNyYwotLS0gL3Vzci9zcmMvc2hhcmUvY29sbGRl Zi5vcmlnL3RyX1RSLklTTzg4NTktOS5zcmMJVGh1IEphbiAgMSAwMjowMDowMCAxOTcwCisr KyAvdXNyL3NyYy9zaGFyZS9jb2xsZGVmL3RyX1RSLklTTzg4NTktOS5zcmMJU3VuIERlYyAy MyAyMjoyNjowNCAyMDA3CkBAIC0wLDAgKzEsMzYgQEAKKyMgbGF0aW4xIChiYWNrd2FyZCBj b21wYXRpYmxlIHdpdGggQVNDSUkpCisjCisjICRGcmVlQlNEOiBzcmMvc2hhcmUvY29sbGRl Zi9sYV9MTi5JU084ODU5LTEuc3JjLHYgMS4xMCAyMDAxLzA2LzEwIDEzOjQzOjQ3IGFjaGUg RXhwICQKKyMKK2NoYXJtYXAgbWFwLklTTzg4NTktMQorb3JkZXIgXAorIyBjb250cm9scwor CTxOVT47Li4uOzxVUz47PFBBPjsuLi47PEFDPjtcCisjCisJPE5TPjs8U1A+OyE7PCFJPjtc Ijs8PDw+OzwvPi8+Pjs8TmI+O1wKKwk8Q3U+OzxDdD47PERPPjs8UGQ+OzxZZT47XAorCSU7 Jjs8Jyw+Oyc7XCg7XCk7KjsrOzwrLT47PC06Pjs8Klg+O1wsOzwtLT47LTsuOy87XAorIyBk aWdpdHMKKwkoMCw8MTQ+LDwxMj4sPDM0Pik7KDEsPDFTPik7KDIsPDJTPik7KDMsPDNTPik7 NDsuLi47OTtcCisjCisJOjtcOztcPDs9Oz47Pzs8P0k+OzxTRT47PFBJPjs8Q28+OzxSZz47 PEF0PjtcCisjIGNhcGl0YWwKKwkoQSw8QSc+LDxBIT4sPEEvPj4sPEFBPiw8QTo+LDxBPz4s PEFFPik7XAorCUI7KEMsPEMsPik7RDsoRSw8RSc+LDxFIT4sPEUvPj4sPEU6Pik7XAorCUY7 Rzs8RC0+O0g7KEksPEknPiw8SSE+LDxJLz4+LDxJOj4pOzxZJz47XAorCUo7Li4uO007KE4s PE4/Pik7KE8sPE8nPiw8TyE+LDxPLz4+LDxPOj4sPE8/Piw8Ty8vPik7XAorCVA7Li4uO1M7 PFRIPjtUOyhVLDxVJz4sPFUhPiw8VS8+Piw8VTo+KTtcCisJVjtXO1g7WTtaO1wKKyMKKwlb O1xcO107Xjs8Jzo+O187PCdtPjs8Jyc+O2A7XAorIyBzbWFsbAorCShhLDxhJz4sPGEhPiw8 YS8+Piw8YWE+LDxhOj4sPGE/Piw8YWU+KTtcCisJYjsoYyw8Yyw+KTtkOyhlLDxlJz4sPGUh Piw8ZS8+Piw8ZTo+KTtcCisJZjtnOzxkLT47aDs8eSc+OyhpLDxpJz4sPGkhPiw8aS8+Piw8 aTo+KTtcCisJajsuLi47bTsobiw8bj8+KTsobyw8byc+LDxvIT4sPG8vPj4sPG86Piw8bz8+ LDxvLy8+KTtcCisJcDsuLi47czs8dGg+O3Q7KHUsPHUnPiw8dSE+LDx1Lz4+LDx1Oj4pO1wK Kwl2O3c7eDsoeSw8eTo+KTt6Ozxzcz47XAorIworCVx7OzxOTz47fDs8QkI+O1x9O347PC5N Pjs8REc+OzxNeT47PERUPjtcCisjIHJlbWFpbnMKKwk8LWE+Ozwtbz4K ------------5AF21BB1FFA4DC7--