09-15-2016, 03:50 PM
So, SuperFlomm just brought a bug to my attention that I'd like some feedback on. After making the changes originally mentioned in this thread, we've been updating names to reflect accented characters correctly. This has been going well except for Ōkami on the PS2, which is showing up in both the # section and the O section of the PS2 category, as seen below:
http://www.sounds-resource.com/playstation_2/0.html
http://www.sounds-resource.com/playstation_2/O.html
I understand why it's happening but it's not something I can fix (it has to do with the character encoding and regular expressions not playing nicely with special characters on the database side). The two options are either to leave it as is (keep the special character and just let it show up in two places) or strip special characters if they are the first character of a game or console name. I'm leaning towards the latter given that the cases where it happens will likely be relatively rare but I'd like some feedback regardless. Thoughts?
http://www.sounds-resource.com/playstation_2/0.html
http://www.sounds-resource.com/playstation_2/O.html
I understand why it's happening but it's not something I can fix (it has to do with the character encoding and regular expressions not playing nicely with special characters on the database side). The two options are either to leave it as is (keep the special character and just let it show up in two places) or strip special characters if they are the first character of a game or console name. I'm leaning towards the latter given that the cases where it happens will likely be relatively rare but I'd like some feedback regardless. Thoughts?