pvignesh92
Honored Contributor

Hi @Manju Chugani​. Yes. In Short, it is not really recommended to save the columns as string if all the values are expected to be numbers.

Here are some of them

  1. Storage Space: Storing numbers as strings can take up more storage space than storing them as numbers. This is because strings are typically represented using Unicode characters, which require more bits to store than the binary representation of numbers.
  2. Performance: Using strings can be slower than using numbers when performing calculations or other operations on the data. Converting strings to numbers before performing calculations can add overhead and reduce performance.
  3. Sorting and Filtering: Sorting and filtering operations can be slower with strings than with numbers. Sorting strings requires additional steps such as converting the strings to a common format and comparing them character by character.
  4. Type Checking: Using strings can make it more difficult to ensure that the data is of the correct type. This can lead to errors and inconsistencies in the data.
  5. Data Integrity: Storing values as strings can increase the risk of data integrity issues, such as data input errors or unexpected data formats. This can make it more difficult to analyze the data and can lead to inaccurate results.