Question about inserting empty string into varchar

Hi there.

(Sorry this is a version 3 question)

Is there any reason why trying to insert an empty string into a varchar column might result in a character zero being inserted instead?

Any help would be appreciated!

(more specifically version 3.0.0 $Rev: 642)

I think I may have partly answered this for myself. By setting the variable to NULL if this is an empty string, then the query method passes the NULL correctly to the database.

Still remains that passing an empty string adds 0 to a varchar column. Looking in the code for the class, I see that the values passed are tested for type and is_string() should identify an empty string correctly as a string type.

Sorry if it took me a while to get back to you, but I haven't got any notifications of your posts.

What you mention is indeed a huge problem with v3.X. It is completely solved however in v4.0+, which in general has huge improvements over v3.0.

My recomendation would be that you update to v4.

You are also very welcome to leave comments on Github, where I do get notifications:
github.com/unreal4u/db_mysqli

Greetings.