[Nikos]

Hello i have a problem at report tables with Greek Lang.
We use Greek lang at Processes without any problem but if I use report tables then i recieve '???????' ta table fields.
Allrdy i have check the Charset is utf8 (at db , table browser etc..)
can any1 help with this ?

thx a lot in advance
Nick

[amosbatto]

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.?

[Nikos]

Hello amosbatto,
Is exactly like yours

Code: Select all

mysql  Ver 14.12 Distrib 5.0.45, for Win32 (ia32)

Connection id:          25216
Current database:       rp_workflow
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.45-community-nt-log MySQL Community Edition (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 4 days 6 hours 15 min 19 sec

thx
Nick

[Nikos]

And with this changes this problem doesnt fixed

Code: Select all

Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8

thx
Nick

[Nikos]

At this it I fix this issue with a trigger.
I use trigger to insert the form fields an works fine

thx
Nick