DDC-3992: Index X bytes of a column #4873

Closed
opened 2026-01-22 14:51:11 +01:00 by admin · 1 comment
Owner

Originally created by @doctrinebot on GitHub (Nov 11, 2015).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user christophe mailfert:

i'm looking for a solution for index X bytes of a column

In SQL:

ALTER TABLE phone*book ADD INDEX (last*name(4));

In Doctrine i try this one but does not work:

@ORM\Index(name="lastname*idx", columns={"last*name(4)"}),

Anyone got a solution ?

Thx.

Originally created by @doctrinebot on GitHub (Nov 11, 2015). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user christophe mailfert: i'm looking for a solution for index X bytes of a column In SQL: ``` sql ALTER TABLE phone*book ADD INDEX (last*name(4)); ``` In Doctrine i try this one but does not work: ``` java @ORM\Index(name="lastname*idx", columns={"last*name(4)"}), ``` Anyone got a solution ? Thx.
admin added the Improvement label 2026-01-22 14:51:11 +01:00
admin closed this issue 2026-01-22 14:51:11 +01:00
Author
Owner

@beberlei commented on GitHub (Feb 16, 2020):

This is outside ORM/DBALs possibilities, you should create the index outside of Doctrine tooling.

@beberlei commented on GitHub (Feb 16, 2020): This is outside ORM/DBALs possibilities, you should create the index outside of Doctrine tooling.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#4873