News for hackers. Stuff that matters.
Re:We have an employee whose last name is Null. He kills our... by Mvandenbergh on Friday August 02, 2013 @06:57AM (#6146310)
You don't need to explicitly support them if you just treat "name" as a freeform, unicode text field.
Re:We have an employee whose last name is Null. He kills our... by Piskvorrr on Friday August 02, 2013 @08:18AM (#6146500)
Well, you can still get bitten by "11. People’s names are all mapped in Unicode code points," as well as the sets 1-8 and 32-36 (people have exactly X names at a given point in time, where X>0); that's not to mention ordering and collation (12,13,18,30). But it's definitely the easiest option, and avoids many common pitfalls (if I had a nickel for every database using latin1 + latin1_swedish_ci because that's the first charset + collation in the list, I'd have a lot of nickels).
Re:We have an employee whose last name is Null. He kills our... by Mvandenbergh on Friday August 02, 2013 @10:53AM (#6147241)
I can see 11, but as long as you're not using the name as a unique key but just as a label then the mutability, non singularity, and non-orderedness aren't such problems.
Re:We have an employee whose last name is Null. He kills our... by Piskvorrr on Monday August 05, 2013 @07:43AM (#6159538)
That makes sense - I was under the impression that you need to keep the name's history etc; even so it wouldn't be much of a problem.