How to insert an empty string into Table editor?
Answered
In IDEA 2016.3 how do I enter an empty string into a varchar field? if I try just hitting enter on a empty editor it puts null into the field not an empty string? This is on MySQL 5 not Oracle. Previously there was a separate menu option to insert null instead of an empty string?
Not mentioned in the IDEA help for modifying a cell.
Please sign in to leave a comment.
Oh I see, its only a problem if it was already null. Trying to replace an empty string over a null doesn't work. But If I change the null to something else first, then go back and change that to an empty string it will change. Faffy, not very obvious but can be done.
Hello Richard,
Related issue is already reported: https://youtrack.jetbrains.com/issue/DBE-3125.
Please follow it.