Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 23 Dec 2007 22:40:12 +0200
From:      Ismail YENIGUL <ismail@EnderUNIX.org>
To:        "Ivan Voras" <ivoras@freebsd.org>
Cc:        freebsd-database@freebsd.org, freebsd-questions@freebsd.org
Subject:   Re[4]: Turkish character sorting on PostgreSQL
Message-ID:  <1601099540.20071223224012@EnderUNIX.org>
In-Reply-To: <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com>
References:  <1605513356.20071219221424@EnderUNIX.org><fkdh2i$vsu$1@ger.gmane.org> <879443695.20071222190910@EnderUNIX.org> <9bbcef730712221435o1f1227a1l1ca840e1474aacfb@mail.gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help

[-- Attachment #1 --]
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 <ismail@enderunix.org> 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"



-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ 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ğ güvenliği kitabının 2. baskısı çıktı!
http://dukkan.acikakademi.com
[-- Attachment #2 --]
diff -ruN /usr/src/share/colldef.orig/Makefile /usr/src/share/colldef/Makefile
--- /usr/src/share/colldef.orig/Makefile	Sun Dec 23 22:36:02 2007
+++ /usr/src/share/colldef/Makefile	Sun Dec 23 22:35:42 2007
@@ -34,6 +34,7 @@
 		sr_YU.ISO8859-5 \
 		sv_SE.ISO8859-1 \
 		sv_SE.ISO8859-15 \
+		tr_TR.ISO8859-9 \
 		uk_UA.CP1251 \
 		uk_UA.ISO8859-5 \
 		uk_UA.KOI8-U
@@ -79,7 +80,6 @@
 US-ASCII_GB18030= la_LN:zh_CN
 US-ASCII_GB2312= la_LN:zh_CN
 US-ASCII_GBK=	la_LN:zh_CN
-US-ASCII_ISO8859-9= la_LN:tr_TR
 US-ASCII_SJIS=	la_LN:ja_JP
 
 ASCIILINKS=	en_AU en_CA en_GB en_NZ en_US
diff -ruN /usr/src/share/colldef.orig/tr_TR.ISO8859-9.src /usr/src/share/colldef/tr_TR.ISO8859-9.src
--- /usr/src/share/colldef.orig/tr_TR.ISO8859-9.src	Thu Jan  1 02:00:00 1970
+++ /usr/src/share/colldef/tr_TR.ISO8859-9.src	Sun Dec 23 22:26:04 2007
@@ -0,0 +1,36 @@
+# latin1 (backward compatible with ASCII)
+#
+# $FreeBSD: src/share/colldef/la_LN.ISO8859-1.src,v 1.10 2001/06/10 13:43:47 ache Exp $
+#
+charmap map.ISO8859-1
+order \
+# controls
+	<NU>;...;<US>;<PA>;...;<AC>;\
+#
+	<NS>;<SP>;!;<!I>;\";<<<>;</>/>>;<Nb>;\
+	<Cu>;<Ct>;<DO>;<Pd>;<Ye>;\
+	%;&;<',>;';\(;\);*;+;<+->;<-:>;<*X>;\,;<-->;-;.;/;\
+# digits
+	(0,<14>,<12>,<34>);(1,<1S>);(2,<2S>);(3,<3S>);4;...;9;\
+#
+	:;\;;\<;=;>;?;<?I>;<SE>;<PI>;<Co>;<Rg>;<At>;\
+# capital
+	(A,<A'>,<A!>,<A/>>,<AA>,<A:>,<A?>,<AE>);\
+	B;(C,<C,>);D;(E,<E'>,<E!>,<E/>>,<E:>);\
+	F;G;<D->;H;(I,<I'>,<I!>,<I/>>,<I:>);<Y'>;\
+	J;...;M;(N,<N?>);(O,<O'>,<O!>,<O/>>,<O:>,<O?>,<O//>);\
+	P;...;S;<TH>;T;(U,<U'>,<U!>,<U/>>,<U:>);\
+	V;W;X;Y;Z;\
+#
+	[;\\;];^;<':>;_;<'m>;<''>;`;\
+# small
+	(a,<a'>,<a!>,<a/>>,<aa>,<a:>,<a?>,<ae>);\
+	b;(c,<c,>);d;(e,<e'>,<e!>,<e/>>,<e:>);\
+	f;g;<d->;h;<y'>;(i,<i'>,<i!>,<i/>>,<i:>);\
+	j;...;m;(n,<n?>);(o,<o'>,<o!>,<o/>>,<o:>,<o?>,<o//>);\
+	p;...;s;<th>;t;(u,<u'>,<u!>,<u/>>,<u:>);\
+	v;w;x;(y,<y:>);z;<ss>;\
+#
+	\{;<NO>;|;<BB>;\};~;<.M>;<DG>;<My>;<DT>;\
+# remains
+	<-a>;<-o>

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1601099540.20071223224012>