and it looks kinda cool. I was going to take it out because I'm not sure what it could break, but I'm thinking about just leaving it there.
I was going to play with using them in column headings on RGFQs. Good to have the heads up on not using it in names or accounts.
I think I just made a coworker's day. I just noticed she has an accent above a letter in her name: é She always just uses a plain e on the computer, but then I remembered this emoji thing. Hey, if someone can have a in their name, then surely they can have an é. I decided to try that in her nickname so it will show up that way on most reports but leave the plain e in the first name field for searching purposes. Hopefully, it won't break anything.
Arena admins...bringing joy in the little things since 2008...
I just updated her name on the email system too. I was going to add it as an email address alias, but it wouldn't take it there. At least it's in the display name.
Go into SQL, right-click the Arena Database and select properties. On the General tab, there's a property for "Collation". You should see something like General_CI_AS. That "CI_AS" part determines if it is Case Insensitive (CI) in the search. It also has Accent Sensitive (AS). If that AS were changed to an AI (Accent Insensitive), then the search would match café when you have a WHERE name = 'cafe' query, as well as your coworker's name.
Maybe check with Arena Dev/Support and see if it is supported to update the Collation setting on the database, or maybe just the Name fields in the core_person table.