I am wondering if the latest version of HelpSpot (3.1.5) has better support for non-latin characters such as Japanese. Looking through the forums, I found:
which mentioned that 4 fields can be modified to minimally support email messages and notes in UTF-8 format:
“minimal change” - minimal set of columns with UTF-8 storage capability
ALTER TABLE HS_Request_History MODIFY tNote longtext CHARACTER SET utf8 NOT NULL;
ALTER TABLE HS_Request_Note_Drafts MODIFY tNote longtext CHARACTER SET utf8 NOT NULL;
ALTER TABLE HS_Request_Pushed MODIFY tComment longtext CHARACTER SET utf8 NOT NULL;
ALTER TABLE HS_Search_Queries MODIFY sSearch varchar(255) CHARACTER SET utf8 NOT NULL;
Is this still the current recommendation, or can HelpSpot support a database structure which is entirely in UTF-8? Sorry to repost this question, but the last thread was back in 2008.