Third gender

[OwlHoot]

There are gender identities, though, not biological sex which is what the original post is about (ignoring the thread title).

Hang on, you seem to know a lot about it. You're not, um, thinking of "transitioning" are you?

[mudskipper]

Hang on, you seem to know a lot about it. You're not, um, thinking of "transitioning" again are you?

FTFY

[darmstadt]

Good for contractors, just think of all that software that had to be changed to add a new field to all forms...

[d000hg]

Good for contractors, just think of all that software that had to be changed to add a new field to all forms...:

actually many organisations do already allow this. LGBT people look at the options in the Gender field when applying for university, jobs, etc, as one way to see how LGBT-friendly the place is. E.g. Is it male/female or male/female/other.

But any database storing gender as a bool is going to need some work. Maybe put "gender modernisation" on your CV?

[suityou01]

actually many organisations do already allow this. LGBT people look at the options in the Gender field when applying for university, jobs, etc, as one way to see how LGBT-friendly the place is. E.g. Is it male/female or male/female/other.

But any database storing gender as a bool is going to need some work. Maybe put "gender modernisation" on your CV?

I'm hoping no databases use bool for this as that would be ridiculous. Char(1) is the way.

[mudskipper]

I'm hoping no databases use bool for this as that would be ridiculous. Char(1) is the way.

Boolean seems fine to me.

Sex? Y/N

[d000hg]

I'm hoping no databases use bool for this as that would be ridiculous. Char(1) is the way.

I can totally see developers thinking "we want to ensure only two values are possible so use true for male and false for female".

[mudskipper]

I can totally see developers thinking "we want to ensure only two values are possible so use true for male and false for female".

That's why you'd call the field YChromosome and not gender.

[suityou01]

That's why you'd call the field YChromosome and not gender.

Epic win

[OwlHoot]

Epic win

Not so fast!

XX or XY are the conventional complement, but some people have XXX, XXY, XYY, XXXX, XXYY, etc

So you'll need to reserve an unsigned int8 for that too