Page with Title contain U+25008 fail to create
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Apr 26 2007, 12:50 AM

Description

Author: kentsin

Description:
When try to create a page with title contain the char U+25008 either create it
directly or rename a existing page the following :

Database error
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

(SQL query hidden)

from within function "Article::insertOn". MySQL returned error "1406: Data too
long for column 'page_title' at row 1 (localhost)".

Version: 1.9.x
Severity: normal
OS: Windows XP
Platform: PC

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:39 PM

• bzimport set Reference to bz9700.

• bzimport added a subscriber: Unknown Object (MLST).

ayg wrote:

What was the full page name that you tried to create? U+25008 should take up
only four bytes by itself.

I have been able to create a page with U+25008.
Marking bug as worksforme.

You're using the experimental MySQL 4.1/5.0 UTF-8 schema, and thus are limited
to MySQL's incomplete UTF-8 support.

Use the default (compatible) schema, which actually works. :)