Values with special characters not shown

When I run a test on a database query with records that have special characters like éàèé then the field values are not shown. Please see the attached screenshot.

This is a DW issue. it occurs with a native DW Recordset as well. The dialog window that we use for showing the test results is the same one used by the Native DW recordset.

As long as you use the correct character set in the MySQLi connection, i believe latin 1, the data will show on your page fine.

Thanks Jason.

If I have an older database with ISO data and need to convert them on the page to UTF8, how do I have to do this? Until now I did it inside the connection string using the following lines:

...
mysql_query("SET CHARACTER SET UTF8", $mydb_db);
mysql_query("SET NAMES UTF8", $mydb_db);

in the MySQLi dynamic connection, you can select the character set to use for the connection.

Great, thanks Jason.

you're welcome.

Hi Jason

I think I have an issue related to this; I have converted most of a site to use mysql_i and all the pages that use this connection display properly. However, pages which use the 'old' connection script do not display properly in Spanish - (or presumably other languages where accents etc are used) - despite the same data from the database being retrieved on the different pages.

I assume this must be a character set issue and am not sure how to set the charset as utf8 in the 'old' connection file.

Currently this is:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connRoSite = "localhost";
$database_connRoSite = "stname";
$username_connRoSite = "uname";
$password_connRoSite = "pwd";
$connRoSite = mysql_pconnect($hostname_connRoSite, $username_connRoSite, $password_connRoSite) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Any help much appreciated

Cheers
Chris

Delete that connection file and create a new connection file with the webassist "Dynamic Connection" using the same name.

It gives the option to set the charset in the user interface.

Thanks Ray - however, I think my setup might be corrupt* in some way, as the + and - buttons on the Databases properties panel are greyed out - is there a different way of initiating things?

(* I've wondered about this fr some time, as often existing recordsets are hidden in the bindings panel until I go to create a new one, then they reappear)

Cheers
Chris

Hi Ray

Jut to let you know that after a reboot, the databases panel + and - were no longer greyed out and your solution worked a treat!

many thanks

Chris
(Given all the issues with installing DW 2015, I might just uninstall everything and start from scratch!)