Skip to content

The name column of the 'users' table should be 254 chars, not 60. #7050

@swampopus

Description

@swampopus

Description of the need

Since the dawn of time, the name column in the database table 'users' has been set to varchar(60). It was like this for all version of Drupal, and has been carried over to Backdrop.

The problem arises when users want to enter their email address as their username, or, if you are using a module like hybridauth , which lets you sign in with Google or Apple, etc., and saves your email address as the user name in the database.

As a result, if a user wants to use a long email address as their username
(ex: [email protected])
It will cause problems.

I know 60 chars is actually probably plenty for 99.9% of all email addresses out there, but why risk the odd edge case?

Proposed solution

Simply alter the name column in the 'users' table be varchar(254), the same as the mail column.

Alternatives that have been considered

I know this is a simple fix for me to do manually to the table, or, to create a module which makes this single change. But it would be nice to throw off the shackles of the arbitrary 60-char-limit for user names once and for all.

🥖 Vive la nom d'utilisateur!

Additional information

Draft of feature description for Press Release (1 paragraph at most)

Backdrop now permits user names to be the same length as email addresses.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions