CODEWITHSUNDEEP
mysqlschemaalter
Roni Hoffman
Roni Hoffman

Reputation: 332

Changing Data Type for a column in MySql has no affect

I am using MySql Workbench.

If I right click on a table and click Alter Table, then change the DataType of a column from VARCHAR to NVARCHAR, apply the changes, then save it. It has no affect on the table the column type remains VARCHAR.

Any Suggestions?

Upvotes: 0

Views: 1551

Answers (1)

Uueerdo
Uueerdo

Reputation: 15961

I don't think MySQL has a specific NVARCHAR type, so much as a specific "type" of VARCHAR. "NATIONAL VARCHAR is the standard SQL way to define that a VARCHAR column should use some predefined character set. MySQL uses utf8 as this predefined character set. Section 10.1.3.6, “National Character Set”. NVARCHAR is shorthand for NATIONAL VARCHAR."

Upvotes: 1

Related Questions