How to insert an empty string into Table editor?

已回答

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. 

0

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.

0

Hello Richard,

 

Related issue is already reported: https://youtrack.jetbrains.com/issue/DBE-3125.

Please follow it.

0

请先登录再写评论。