Change the charset to view the records.

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