MySQL Bugs: #32493: NVARCHAR type specifier not mentioned in manual

Bug #32493	NVARCHAR type specifier not mentioned in manual
Submitted:	19 Nov 2007 13:05	Modified:	26 Nov 2007 17:08
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
The pages http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html
and http://dev.mysql.com/doc/refman/5.1/en/charset-national.html mention
NCHAR but not NVARCHAR although it is also a valid type specifier.

The only occurance of NVARCHAR on dev.mysql.com (according to google)
is somewhere in the Connector/J changelogs http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-0.html
and in a dev zone article
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
but nowhere in the actual manual contents.

How to repeat:
Check that the NVARCHAR type works:

  mysql> create table t1(n nvarchar(100));
  Query OK, 0 rows affected (0.33 sec)

  mysql> show create table t1\G
  *************************** 1. row ***************************
         Table: t1
  Create Table: CREATE TABLE `t1` (
    `n` varchar(100) CHARACTER SET utf8 DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1

and then search for it in the manual

Suggested fix:
Add reference to NVARCHAR anywhere NCHAR is mentioned already

Looks like NVARCHAR was added in 4.1.1.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.