Names with accents

mariod over 7 years ago

Hello, we have a update process that fails if the users name includes accents. Has anyone experienced issues with names having accents and if so, how did you resolve it? We are on version 7.8 and plan to move into v16.2 in the next few months.

Discussion posts and replies are publicly visible

Parents

0 chetany
A Score Level 1
over 7 years ago

@mariod, My guess is that UTF-8 is not enabled for your DB schema.
accents are just Unicode characters.
Please check if you have enabled utf-8 set on your tables and DB schemas.
Appian supports Unicode characters. But, the DB schema should support it. You need to enable it while creating the DB schema. An example:
CREATE DATABASE mydb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;

To check if your DB Table is using utf-8, use this command: SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "schemaname"; where schemaname is the name of the schema.
If it is not utf-8, you need to set it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chetany
A Score Level 1
over 7 years ago

@mariod, My guess is that UTF-8 is not enabled for your DB schema.
accents are just Unicode characters.
Please check if you have enabled utf-8 set on your tables and DB schemas.
Appian supports Unicode characters. But, the DB schema should support it. You need to enable it while creating the DB schema. An example:
CREATE DATABASE mydb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;

To check if your DB Table is using utf-8, use this command: SELECT default_character_set_name FROM information_schema.SCHEMATA
WHERE schema_name = "schemaname"; where schemaname is the name of the schema.
If it is not utf-8, you need to set it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data