Jump to content

Polynesian Okina (punctuation) character

Rik Brown

Recommended Posts

A little explanation first....

The "okina" character which looks like a reverse single quote mark is defined in the Wikipedia as:

"The ʻokina (Hawaiian pronunciation: [ʔoˈkinɐ]), also called by several other names, is a unicameral consonant letter used within the Latin script to mark the phonemic glottal stop, in many Polynesian languages." See this Link.

My JR 3.13.1 MySQL database is setup to use the utf8mb4 character set with unicode_ci so I assumed the "okina" character would be permitted.

However, when I try to use the "okina" character online when editing a listing (any field that I've tested), it truncates the word starting with the "okina" character. If you cut and paste one of the samples in this message you can see what I mean.

So the city named Kāneʻohe in "Hawaii" gets truncated and saved as "Kāne" instead of the entire word. Likewise, the state name Hawaiʻi becomes "Hawai".

I'm wondering whether utf8mb4 doesn't allow for the "okina" character? Or, is there another character set that I need to use?

Link to comment
  • Create New...