Re[4]: Turkish character sorting on PostgreSQL

Ismail YENIGUL <[email protected]> Sun, 23 Dec 2007 22:40:12 +0200
Newsgroups gmane.os.freebsd.questions,gmane.os.freebsd.devel.database
Organization EnderUNIX
Message-ID <[email protected]> 
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 <[email protected]> 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.
> _______________________________________________
> [email protected] mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
> "[email protected]"



-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ 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

_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[email protected]"
tr_TR.ISO8859-9.diff (application/octet-stream, 1.9 KB) 
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>