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
1767 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Names with accents
mariod
over 8 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
0
mariod
over 8 years ago
this is referring to a user update process and it seems to fail when retrieving the users name. The only language we have configured is US English.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chetany
A Score Level 1
over 8 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
0
mariod
over 8 years ago
thanks for the reply.
My primary data source is setup on MS SQL 2008 and the character set is iso_1. If I'm not mistaken, a column would have to be NVARCHAR to support unicode. are you saying the primary data source is causing the issue?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel