Bug #1861 create/alter database ... character set giving error
Submitted: 17 Nov 2003 6:00 Modified: 17 Nov 2003 7:11
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.0.15 OS:Linux (mandrake 9.2)
Assigned to: Dean Ellis CPU Architecture:Any

[17 Nov 2003 6:00] [ name withheld ] 
Description:
I have run the following command taken (with copy/paste) from your site chapter 9.3.2:

CREATE DATABASE db_name
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

and got the following error message:

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line 2

as I did it exactly like the manual, we have here two problems:
1- what's wrong with the command?
2- the manual needs to be corrected

PS
please email me whatever you know because I'm not frequent here...

php@yossin.com

How to repeat:
run the example from chapter 9.3.2 from the manual:

CREATE DATABASE db_name
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
[17 Nov 2003 7:11] Dean Ellis 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

This is a MySQL 4.1 feature.

Thank you.