Author: tille Date: 2012-05-06 09:52:21 +0000 (Sun, 06 May 2012) New Revision: 2264
Modified: udd/sql/bibref.sql Log: Handle UTF-8 thin spaces Modified: udd/sql/bibref.sql =================================================================== --- udd/sql/bibref.sql 2012-05-06 09:42:59 UTC (rev 2263) +++ udd/sql/bibref.sql 2012-05-06 09:52:21 UTC (rev 2264) @@ -29,7 +29,11 @@ SELECT DISTINCT '@Article{' || bibkey.value || CASE WHEN bibauthor.value IS NOT NULL THEN E',\n Author = "{' || bibauthor.value || '}"' ELSE '' END || - CASE WHEN bibtitle.value IS NOT NULL THEN E',\n Title = "{' || replace(bibtitle.value, '_', '\_') || '}"' ELSE '' END || + CASE WHEN bibtitle.value IS NOT NULL THEN E',\n Title = "{' || + replace(replace(bibtitle.value, '_', '\_'), E'\xe2\x80\x89', '\,') -- TeX syntax for '_' and UTF-8 "thin space" + -- see http://www.utf8-chartable.de/unicode-utf8-table.pl?start=8192&number=128&utf8=string-literal + || '}"' + ELSE '' END || CASE WHEN bibbooktitle.value IS NOT NULL THEN E',\n Booktitle = "{' || bibbooktitle.value || '}"' ELSE '' END || CASE WHEN bibyear.value IS NOT NULL THEN E',\n Year = "{' || bibyear.value || '}"' ELSE '' END || CASE WHEN bibmonth.value IS NOT NULL THEN E',\n Month = "{' || bibmonth.value || '}"' ELSE '' END || _______________________________________________ Collab-qa-commits mailing list Collab-qa-commits@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/collab-qa-commits