Filtering for a user name returns an empty result if name contains certain special characters
In Management Console—Users, if iHub uses a PostgreSQL database to store metadata, filtering on a user name returns an empty result when certain special characters are used in the filter string. For example, if you filter on a user name containing one or more of the letters, é, à, è, ü, ä, ö, ê, or ô, iHub does not find the name, using following default locale collation and type settings:
CREATE DATABASE iserver
WITH OWNER = postgres
ENCODING = 'UTF8'
LC_COLLATE = 'C'
LC_CTYPE = 'C'
CONNECTION LIMIT = -1;
To resolve this problem, perform the following tasks:
1 Export the iserver database to a dump file.
2 Create a new database named iserver. If you are running iHub on a Windows machine, execute the following DDL statements to recreate the database:
CREATE DATABASE iserver
WITH OWNER = "postgres"
TEMPLATE = template0 ENCODING = 'UTF-8'
LC_COLLATE = 'English, United States'
LC_CTYPE = 'English, United States'
CONNECTION LIMIT = -1;
If you are running iHub on a Linux machine, execute the following DDL statements to recreate the database:
CREATE DATABASE iserver
WITH OWNER = "postgres"
TEMPLATE = template0 ENCODING = 'UTF-8'
TABLESPACE = pg_default
LC_COLLATE = 'en_US.UTF8'
LC_CTYPE = 'en_US.UTF8'
CONNECTION LIMIT = -1;
3 Import the data back into the newly created iserver database.