Hi Ernst,

There are currently 2 issues that we are aware of with UTF-8 characters not displaying correctly in Yellowfin.

-In the filter pop-up page.
-On report section tabs.

Where are you seeing this issue, is it mentioned above?
If so, we are planning on fixing it in a future release, though too early to tell if it can go into the 6.3 November release.

Regards,
David

Hi Ernst,

I have inserted an umlaut into my MySQL database and it is appearing correctly in my instance of Yellowfin:





and this is how my variable are set:

[code]mysql> show variables like 'ch%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:MySQLsharecharsets |
+--------------------------+--------------------------+
8 rows in set (0.00 sec)[/code]

I wonder if you could try the above values and let us know if there was any improvement.

Also, just out of interest, my connection string didn't specify UTF-8, here it is:

[code]jdbc:mysql://localhost:3306/test?zeroDateTimeBehavior=convertToNull[/code]

Another thing to do if trying the above character set values doesn't help would be to run the following query and show us the resultset:

[code]mysql> show variables where variable_name like 'collation%';[/code]

Regards,
Dave

Hi Dave,

I have found the problem, there are UTF-8 characters in the latin1 columns.

I use a virtual table to solve the problem temporarily.
[code]select
nr,
CONVERT(CONVERT(firma01 USING BINARY) USING utf8) as firma01UTF8
from
kontakte[/code]


[code]mysql> show variables where variable_name like 'collation%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)

mysql>[/code]

Hi Ernst,

Nice work!
We're still a little confused as to why it works for us though, we haven't done anything special, it just works.

Regards,
David