Hi Nick,
Log into the MySQL database which ProcessMaker is using and check which character set is being used for the rp_<WORKSPACE> database.
Example:
Code: Select all$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 152
Server version: 5.0.51a-24 (Debian)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mydata |
| mysql |
| rb_workflow |
| rp_workflow |
| test |
| wf_workflow |
+--------------------+
7 rows in set (0.05 sec)
mysql> use rp_workflow;
Database changed
mysql> status;
--------------
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
Connection id: 152
Current database: rp_workflow
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.51a-24 (Debian)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 1 day 2 hours 54 min 13 sec
Threads: 1 Questions: 15766 Slow queries: 0 Opens: 407 Flush tables: 1 Open tables: 64 Queries per second avg: 0.163
--------------
When you issue the "status" command, what are your character sets for Server, Db, Client and Conn.?