Timeline for Storing sports teams with multiple alternative names
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 5, 2021 at 0:43 | answer | added | Rick James | timeline score: 0 | |
| S Apr 29, 2021 at 15:04 | history | suggested | Doug Deden | CC BY-SA 4.0 |
minor typos
|
| Apr 29, 2021 at 14:36 | review | Suggested edits | |||
| S Apr 29, 2021 at 15:04 | |||||
| Apr 29, 2021 at 11:25 | comment | added | Vérace |
Here in Ireland, many people use both Irish and English versions of their names - and many names have variant spellings. What we did was to have the name as entered (display_name) - and then have a generated column - remove spaces, all letters capitalised, all apostrophes, hyphens and accents removed and stored the result - i.e. Ó hUiggin would become OHUIGINN- I can give you an example if you like as part of an answer if you think it'll help. With regular expressions, it's even easier - none then! MySQL >= 8.
|
|
| Apr 29, 2021 at 4:59 | answer | added | user228762 | timeline score: 0 | |
| Apr 29, 2021 at 2:55 | review | First posts | |||
| Apr 29, 2021 at 4:59 | |||||
| Apr 29, 2021 at 2:52 | history | asked | user1822227 | CC BY-SA 4.0 |