[RANGER-3071] Supporting character set which is not included in latin1

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0, 2.2.0
• Component/s: Ranger
• Assignee: Dineshkumar Yadav
• Reporter: Dineshkumar Yadav
• Created: 04/Nov/20 08:59
• Updated: 24/Aug/21 23:35
• Resolved: 11/Nov/20 12:15

Description

Currently we are supporting only character set included in latin1. Though most of the character supported by Latin1 but not all character used in different languages.

Eg. csabahun4árvíztűrő has character like ű and ő. which is not supported by Latin1.
This need to be fixed for all the DB supported by Ranger.
MS SQL server is not able to handle such character. Other DB flavors are handling it currently

Solution:
changing varchar datatypes to Nvarchar for UserName, GroupName and RoleName only.