charlie-map / wiki-suggestor-service

A C backend that makes suggestions for the Wikiread extension
0 stars 0 forks source link

Database Issues on Extended ASCII / UTF-8 #15

Open charlie-map opened 2 years ago

charlie-map commented 2 years ago

Wikipedia articles often contain extended ASCII characters from to ÿ (128-255). The implementation of mysql.h in C seems unable to handle extended ASCII characters. My suggestion points down pulling the binary blobs from the MYSQL database instead of utilizing the library. Thereafter, the binary blob transcribes to extended ASCII (or UTF-8 to leap focus more broadly), which can then send to the frontend using charset=utf-8 in the HTTP headers.