Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1642 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
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.
OriginalPostID-235249
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