ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dineshkumar Yadav <dineshkumar.ya...@outlook.com>
Subject Re: Review Request 73003: RANGER-3071 : Supporting character set which is not included in latin1
Date Thu, 05 Nov 2020 14:27:05 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73003/
-----------------------------------------------------------

(Updated Nov. 5, 2020, 2:27 p.m.)


Review request for ranger, Ankita Sinha, Gautam Borad, Kishor Gollapalliwar, Abhay Kulkarni,
Mehul Parikh, Pradeep Agrawal, Vishal Suvagia, and Velmurugan Periasamy.


Bugs: RANGER-3071
    https://issues.apache.org/jira/browse/RANGER-3071


Repository: ranger


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.


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.


Diffs
-----

  security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql addb56677 
  security-admin/db/sqlserver/patches/050-update-datatype-to-nvarchar.sql PRE-CREATION 


Diff: https://reviews.apache.org/r/73003/diff/1/


Testing
-------

After Patch non-latin charactres are also allows in UserName, GroupName and RoleName


Thanks,

Dineshkumar Yadav


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message