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:

• How to edit records from a capture link.

  In this article, see how to create a binding to edit a record from a grid used in a capture binding. We cannot use the edit link in this case, as the edit button will not be available when we access the grid to capture a value. Taking into account ...