newLISP Access MySQL Chinese garbled

The standard MySQL module using NEWLISP or the Artful code module are garbled in Chinese.

Here's how to fix it:

First make sure that MySQL is internally set to UTF-8,

But when viewed with newLISP, it is still part of the Latin.

Use the following command to resolve:

> (mysql:query "SET character_set_client = UTF8;") True (mysql:query "SET character_set_connection = UTF8;") True> (mysql:query "SET character_set_results = UTF8;")

Now check again:

> (mysql:query "SHOW VARIABLES like ' character% ';") True> (Dotimes (x (mysql:num-rows)) (println (Mysql:fetch-row))) ("Character_set_client" "UTF8") ("character_set_ Connection "UTF8") ("Character_set_database" "UTF8") ("Character_set_filesystem" "Binary") ("Character_set_results") "UTF8") ("Character_set_server" "UTF8") ("Character_set_system" "UTF8") ("Character_sets_dir" "/usr/share/mysql/") charsets/") (" Character_sets_dir ""/usr/share/mysql/charsets/")

It's done now.

newLISP Access MySQL Chinese garbled