On 20 Sep 2014, at 9:42pm, Petite Abeille <petite.abei...@gmail.com> wrote:
> Your last name contains invalid characters > http://blog.jgc.org/2010/06/your-last-name-contains-invalid.html Ah yes, John Graham-Cumming. One of those sneaky non-standard-format foreign names. Probably a terrorist. On 20 Sep 2014, at 9:27pm, John Hascall <hasc...@gmail.com> wrote: > The problem with your suggestion of 'two uses => two fields' is that no > sooner do you do that then somebody comes up with additional uses, for > example, formal greeting, informal greeting, the appropriate form for > government form X123, and so on.... Banks I've worked with include a field called "Salutation" which says things like "Dear Ms. White" or "Dear Mrs. White" depending on the account-holder's preference. Financial and legal institutions, by the way, are the toughest at getting this right. They have a legal requirement to know the account-holder's commonly-used form of name. Not some twisted abbreviated version of it. If the account-holder calls themself Tarquin Fin-tim-lin-bin-whin-bim-lim-bus-stop-F'tang-F'tang-Olé-Biscuitbarrel that's what they have to have in their database. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
