Change the charset to view the records.
When an error appears in the charset of the special characters as in the image below:
This happens when the database charset and the script case charset are not the same but we can no longer edit it in the database.
We use the following code in the OnRecord event of the grid.
{field} = mb_convert_encoding ({field}, 'utf-8');
For example:
and will result in:
Related Articles
How to change the log module table
After creating the Scriptcase log module, it is possible to change the table. When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database. How to edit log ...
How to change the application's state in run time
To change the properties of application execution, changing their form of execution than initially planned, Scriptcase has a macro called sc_apl_conf. The macro should be used as follows: sc_apl_conf ( Application , property , value ) ; So, we can ...
Change user "admin" permissions
Many times it happens that we modify the permissions of the admin user, and when wanting to verify some configurations or when wanting to modify some characteristics of the ScriptCase we can not have access since the permissions were changed. So what ...
Limit number of records to be displayed in the Grid
To limit the number of records to be displayed, we will use the Limit function within the query where they bring the data of a certain table. For example in this way: Then only 5 records are shown:
Change Time Zone in the php.ini
Many times we find ourselves in the situation that the time zone configured by the tool does not correspond to our area, so we proceed to change it in the Configuration: Options > Settings: The problem is when the changes are not saved, then, what we ...