liming0 commented on issue #19026: URL: https://github.com/apache/shardingsphere/issues/19026#issuecomment-1182708049
> I have no idea for how to support `LIKE`, any suggestions? > I have no idea for how to support `LIKE`, any suggestions? 我现在的想法是将内容拆分成x个字符一组，然后将每组分别加密，再拼接起来存储，在查询时重复分组加密的步骤，再进行查询即可；这种方式目前有两个点需要控制：一是加密后的字符会比较长，这种方式属于用存储空间来实现这个需求；二是需要控制变量x的大小，不能太短，太长了也会影响搜索体验 My idea now is to divide the content into groups of X characters, then encrypt each group separately, and then splice them together for storage. When querying, repeat the steps of grouping encryption, and then query; At present, there are two points to be controlled in this method: first, the encrypted characters will be relatively long. This method uses storage space to realize this requirement; Second, we need to control the size of variable x, which should not be too short. Too long will also affect the search experience -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
