wpdb::prepare function null value convert to empty String

[mazharul78]

In WordPress core, there is an issue where prepare functions null values convert to empty strings when interacting with the database. This causes problems for database table columns defined with NOT NULL constraints, leading to the insertion of empty strings instead of retaining null values.

[mazharul78]

The database table contains three columns: id, name, and email. The id column is an auto-increment primary key. The name column is nullable, meaning it can contain null values. The email column is set to not null, ensuring that it always contains a value.

[mazharul78]

The email column is not null, but inserting null into email results in an empty string.