How to use the Accent insensitive option
To use this option in applications that use PostgreSQL it will be necessary to enable the UNACCENT extension.
This extension is natively available in PostgreSQL as of version 10
Enabling extension
1 - Connect to your DB instance as a user who has administrator privileges.
If you do not have access to the admin user of your database, contact your DBA or your shared hosting support
2 - To activate the extension, use the CREATE EXTENSION command as shown below.
- CREATE EXTENSION unaccent;
Now your database will have the extension enabled and the Accent insensitive feature can be used.
This procedure must be performed individually for each database
Check if the extension is available in your PostgreSQL
The UNACCENT extension is available natively in your PostgreSQL database starting with version 10.
However, it can be used from version 9.5.24 onwards.
To check if the extension is available in your database, run the command below:
- SELECT * FROM pg_available_extensions() WHERE name = 'unaccent';
When available this will be the result:
Related Articles
Use of the log in Scriptcase
We proceed to create a security module to use the log. 1 - Follow this tutorial to create a security module: https://www.scriptcase.net/docs/en_us/v9/manual/10-modules/02-security-module/ 2 - Proceed with the log in the top menu option Module > Log > ...
How to configure a new rule in the Save grid option
The Option Save Query allows the layouts to be saved publicly or with restricted access. * Public - Anyone who has access to the application will have access to the saved Layout * Use Rule - Allows the layouts to be saved with restricted access. In ...
How to use local storage in your browser
In this article we'll learn how to implement a system using the localstorage of your browser. First, we'll use ES6 to create a class in javascript This class has the atributes year, month, day, category, description and a value for expense. class ...
Enabling hotkeys on Scriptcase
Scriptcase has shortcut keys for various features within the tool. The use of shortcut keys makes it easier to manipulate the tool, making access to features more intuitive and quick. To enable hotkeys, go to the top menu Options -> My Scriptcase. On ...
Enabling Nested Grid export on XLS
You can enable Nested Grid exports when you want to export in XLS format. This option is useful when you want to generate complete XLS reports. To enable Nested Grid export, go to the menu Nested Grid -> Settings. Then, in the XLS option, you can ...