Using Appian Cloud DB MySQL, trying to import the SQL file which contains the German letters like Ö,ä with the character set utf-8. But for some rows these letters were replaced with special characters like ?, symbols,etc. Do we need to do with any other character set. If so, will it affect other characters which are not in German?
Discussion posts and replies are publicly visible
The best solutions which I tried are:
1. to use the characterset utf8_unicode_ci or or utf8_bin
utf8_unicode_ci
or or utf8_bin
2. use the characterset utf8mb4 and the collation utf8mb4_unicode_ci in MySQL!
2. use the characterset
utf8mb4
utf8mb4_unicode_ci
Thanks Arun,
we are using the same collation with character set utf-8. But issue exists.