Rik Brown Posted March 1, 2022 at 12:56 AM Share Posted March 1, 2022 at 12:56 AM 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
Alejandro Posted March 1, 2022 at 10:33 AM Share Posted March 1, 2022 at 10:33 AM This section is only visible with a valid subscription. If you have a valid subscription, please login. Link to comment
Recommended Posts