Use Norms

Supported

  • Encrypt/decrypt one or more columns in the database table;
  • Compatible with all regular SQL.

Unsupported

  • Need to process original inventory data before encryption;
  • Encrypted fields cannot support case insensitive queries;
  • The value of encryption columns cannot support comparison, such as: >, <, ORDER BY, BETWEEN, LIKE, etc;
  • The value of encryption columns cannot support calculation, such as AVG, SUM, and calculation expressions.