Not all values are being saved in the database

Guest User

Hi Team

We are investigating some issues where we noticed. Some values are not all being saved although we made validations on the client side. The problem now is why is this is a case? when we bugged from the server side no problem, could it be the fact that all fields from the sql datatypes being used as varchar?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad Imran Ansari3y ago
Accepted answer
The problem is directly related to the SQL data types being used as varchar. SQL data types define the type of data that can be stored in a particular column, but they do not typically affect whether or not data is saved.

However, using appropriate data types in your SQL database is still important for data integrity and efficient storage. Using varchar for all fields may not be the best approach, as it allows for variable-length strings and can potentially lead to data inconsistencies or storage inefficiencies.

If you will go with varchar data type then you also need to apply data validation on the server side. Even if you have validations on the client side, it is crucial to validate the data on the server side as well. Client-side validations can be bypassed or modified, so server-side validations act as an additional layer of security and data integrity.
Vishal Joshi3y ago
Hello

yes, varchar datatype can create problems if you are storing Unicode or Non-English character data types. In that case, you need to use nvarchar data type to store values.

Checkout the below link for reference.

https://www.educative.io/answers/what-is-the-difference-between-varchar-and-nvarchar

Thanks