Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
C
Core
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 932
    • Issues 932
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
  • Development
  • Core
  • Issues
  • #1306

Closed
Open
Opened Oct 08, 2019 by justinfreeman (Agileware)@justinfreeman🚴🏿Developer

Standardise length of Title fields in CiviCRM database schema, use 255 characters for all

Standardise length of Title fields in CiviCRM database schema, use 255 characters. Currently, Title fields range in length: 64, 127 and 255 characters. See https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/I18n/SchemaStructure.php

Using a larger length gives users more ability to use descriptive titles. Having a range of different lengths is confusing.

Side note: If we're going to go larger than 255 characters than I think CiviCRM would perform better by converting VARCHAR 255 to TEXT. see https://nicj.net/mysql-text-vs-varchar-performance/ and https://stackoverflow.com/questions/25300821/difference-between-varchar-and-text-in-mysql

This request was raised in response to https://github.com/civicrm/civicrm-core/pull/15418

Agileware Ref: CIVICRM-1331

Edited Oct 08, 2019 by justinfreeman (Agileware)
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: dev/core#1306