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:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[19 Nov 2007 13:05] Hartmut Holzgraefe
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
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

and then search for it in the manual

Suggested fix:
Add reference to NVARCHAR anywhere NCHAR is mentioned already
[26 Nov 2007 16:36] Paul DuBois
Looks like NVARCHAR was added in 4.1.1.
[26 Nov 2007 17:08] Paul DuBois
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.