Announcement

  •  » Engine
  •  » Tags names - binary

#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
13809

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
13809

Re: Tags names - binary

No, keep it that way if it's not mandatory. Users can merge tags by themselves.

Offline

 
  •  » Engine
  •  » Tags names - binary

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact