🌍
English
Announcement
- [2025-05-27] Anonymous Piwigo Statistics: What They Reveal
- [2025-05-23] Piwigo AI: Artificial Intelligence is coming to Piwigo
- [2025-03-12] Piwigo 15.5.0 : batch manager gets more stable
- [2025-02-21] Piwigo 15.4.0 : SEO improved, load reduced, bugs fixed
- [2024-12-20] Piwigo 15.3.0 : same as 15.2.0 but compatible with PHP 7
#1 2014-04-08 21:36:01
- rvelices
- Former Piwigo Team
- 2005-12-29
- 1960
Tags names - binary
Hello team,
Today the tag name in tags table is marked as binary. I would like to pass it to "normal" text. I would like to simplify all the code in place for quick search in order to take full advantage of MySql full text engine.
In addition, it will avoid having tags "party" and "Party" just because they were entered at different times with different tools.
The migration task is not obvious (in case you already have "party" and "Party") ...
What do you think ?
Offline
#2 2014-04-08 21:39:18
- plg
- Piwigo Team
- Nantes, France, Europe
- 2002-04-05
- 13936
Re: Tags names - binary
Hi rvelices,
I think it is a good idea to avoid having "Party" + "party" in the same Piwigo. Do you propose to merge tags if case is encountered?
Offline
#3 2014-04-08 22:46:41
- rvelices
- Former Piwigo Team
- 2005-12-29
- 1960
Re: Tags names - binary
plg wrote:
I think it is a good idea to avoid having "Party" + "party" in the same Piwigo. Do you propose to merge tags if case is encountered?
yes.
Offline
#4 2014-04-09 08:41:38
- rvelices
- Former Piwigo Team
- 2005-12-29
- 1960
Re: Tags names - binary
plg wrote:
Hi rvelices,
I think it is a good idea to avoid having "Party" + "party" in the same Piwigo. Do you propose to merge tags if case is encountered?
In fact as a second thought, this would not be required as the name is not a unique key of tags table. Should I do it anyway ?
Offline
#5 2014-04-09 09:05:42
- plg
- Piwigo Team
- Nantes, France, Europe
- 2002-04-05
- 13936
Re: Tags names - binary
No, keep it that way if it's not mandatory. Users can merge tags by themselves.
Offline