How to use the Accent insensitive option

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