Template:Lowercase title/doc: Difference between revisions

Blanked the page
(Adding SQL)
(Blanked the page)
Line 1:
{{Documentation subpage}}
<!--
Kendeo
-->
{{TOCright}}
 
== Usage ==
{{nosubst}}
 
Simply add the tag <code><nowiki>{{lowercase title}}</nowiki></code> at the beginning of a page (and optionally, at the beginning of its talk page). There are no parameters. The tag will only decapitalize the first letter of the page's name in the title at the beginning of the page. Examples:
 
{| CLASS="wikitable"
|-
! Page name !! Will display
|-
| [[EBay]], [[IPod]], etc. || eBay, iPod, etc.
|-
| [[Talk:EBay]] || Talk:eBay
|}
 
== Issues ==
The template does '''not''' work together with other title modification templates: you need to use DISPLAYTITLE directly and make sure it's the last DISPLAYTITLE on the page. For example, to make "Example" italic and lowercase, use <code><nowiki>{{DISPLAYTITLE:''example''}}</nowiki></code>.
 
When using the template on redirect pages, the template must be moved ''after'' the redirect, since otherwise it will break the redirection. This, however, limits the template to have an effect only when viewing the redirect page directly. Nevertheless, it is still useful in this scenario in order to document the proper capitalization of a term.
 
== Technical ==
This template wraps the [[Help:Magic words|magic word]] DISPLAYTITLE so that it works automatically in any namespace (main, talk, template, etc.) to decapitalise the first letter of the name of a page it is transcluded on.
 
<source lang=sql>
/* Page using a lowercase title, with or without {{lowercase}} */
SELECT page_title, pp_value AS displaytitle
FROM page
JOIN page_props ON pp_page=page_id AND pp_propname="displaytitle"
WHERE page_namespace=0
AND CONVERT(pp_value USING utf8mb4) COLLATE utf8mb4_bin /* &#greek; */
REGEXP "^([_ :]+|<[^<>]+>)*([[:lower:]]|&#9[4-6][0-9];)"
</source>
 
== See also ==
* [[Wikipedia:Naming conventions (technical restrictions)#Lowercase first letter]]
{{WrongTitleExamples}}
 
<includeonly>
[[Category:Correct title templates]]
</includeonly>
Anonymous user