Gender Symbol
Type Registry
Gender Symbol
identity.person.gender_symbol Unicode symbol representing gender (♂, ♀, ⚧, etc.).
Domain identity›person
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "♂"
→ identity.person.gender_symbol DuckDB
Detect
SELECT finetype('♂');
-- → 'identity.person.gender_symbol' Cast expression
CAST({col} AS VARCHAR) Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'identity.person.gender_symbol'; JSON Schema
finetype schema identity.person.gender_symbol {
"$id": "https://noon.sh/schemas/identity.person.gender_symbol",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Unicode symbol representing gender (♂, ♀, ⚧, etc.).",
"examples": [
"♂",
"♀",
"⚧"
],
"pattern": "^[♂♀⚧⚪]$",
"title": "Gender Symbol",
"type": "string"
} Examples
♂♀⚧