Quotes appear when field type is TEXT and I use default 'as defined' · Issue #16801 · phpmyadmin/phpmyadmin · GitHub
Skip to content

Quotes appear when field type is TEXT and I use default 'as defined' #16801

@evilKabab

Description

@evilKabab

Hello.
I guess I found a bug.

Server is CentOS 7 latest. Phpmyadmin is 5.1.0 english running on php 7.3.27 fpm. DB is MariaDB 10.2.37. Apache/2.4.6, mysqlnd 5.0.12-dev - 20150407.

So I created a filed with type TEXT, set default value to 'as defined:' - empty string. After saving that I see that default value looks as two single quotes (''). Strange since right above I see VARCHAR with same default not displaying any quotes for empty string. If I try to change that TEXT field it gets even worse not it displays single quotes escaped with backslashes ('').

See screenshots attached

Michael Sosonkin
fig1
fig2
fig3
fig4

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing feature

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions