Wikipedia:Database reports/Short descriptions containing invalid space characters

Short descriptions containing Unicode space characters other than the usual U+0020. To help editors locate these non-standard space characters, non-breaking spaces and thin spaces are shown in this report as their character entities,   and  ; all other spaces (including other width variants of the non-breaking space) are shown as a fake character entity, &othersp;.

To fix these errors, convert non-standard space characters to regular space characters. See the Manual of Style section on invisible characters for more guidance.

See also Wikipedia:Database reports/Short descriptions containing possibly invalid characters and WP:SDFORMAT.

{{Database report

|sql =

SELECT page_title AS 'Page',

REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(CONVERT(pp_value USING utf8mb4), '\\x{00a0}', ' '), '\\x{2009}', ' '), '(?! ):space:', '&othersp;') AS 'Short description'

FROM page_props

JOIN page ON pp_page = page_id AND page_namespace = 0

WHERE pp_propname = 'wikibase-shortdesc'

AND CONVERT(pp_value USING utf8mb4) REGEXP '(?! ):space:'

ORDER BY Page;

|wikilinks = 1

|excerpts =

|comments =

|widths =

|interval = 1

|header_template = static row numbers

|table_class = wikitable sortable static-row-numbers static-row-header-text

|table_style = overflow-wrap: normal

|pagination = 4000

|max_pages =

}}

{{static row numbers}}

class="wikitable sortable static-row-numbers static-row-header-text" style="overflow-wrap: normal"
scope="col" | Page ! scope="col" | Short description
Archibald Campbell (bishop) | Bishop of the Scottish Episcopal Church (died 1744)
William Killigrew (Chamberlain of the Exchequer) | English courtier (died 1622)

----

{{Database report/footer|count=2|query_runtime=60.21|last_updated=05:26, 28 June 2025 (UTC)}}

{{Database report end}}