Specifying the Character Set of a Character String (Cast Operator)

    
mysql>
mysql> CREATE TABLE mytable (
    ->   titleID int(11),
    ->   title varchar(100),
    ->   subtitle varchar(100),
    ->   edition tinyint(4),
    ->   publID int(11),
    ->   catID int(11),
    ->   langID int(11),
    ->   year int(11),
    ->   isbn varchar(20),
    ->   comment varchar(255),
    ->   ts timestamp,
    ->   authors varchar(255),
    ->   PRIMARY KEY  (titleID)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql>
mysql> INSERT INTO mytable VALUES (1,'Linux','Installation',5,1,57,2,2000,NULL,NULL,'2005-02-28 13:34:21','Michael'),
    ->                           (2,'Excel',NULL,NULL,2,3,NULL,2000,NULL,NULL,'2005-02-28 13:34:22','David'),
    ->                           (3,'XML',NULL,NULL,1,2,NULL,1997,NULL,NULL,'2005-02-28 13:34:22','Edwards'),
    ->                           (4,'PHP',NULL,NULL,3,6,NULL,2000,NULL,NULL,'2005-02-28 13:34:22','Tom'),
    ->                           (5,'MySQL','',0,3,34,NULL,2000,'','','2005-02-28 13:34:22','Paul'),
    ->                           (6,'Java',NULL,NULL,4,34,NULL,1999,NULL,NULL,'2005-02-28 13:34:22','Tim');
Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql>
mysql>
mysql>
mysql> INSERT INTO mytable (title) VALUES( _utf8 'title in UTF-8 encoding');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)

Related examples in the same category

1.	Set DEFAULT CHARSET=latin1
2.	The CHARSET() function identifies the character set used for a specified string
3.	Get CHARSET
4.	Get the charset and collation information
5.	Optionally, you can specify a default character set and sort order:
6.	Change the Character Set of All Text Columns
7.	MySQL Character Set Variables
8.	Changing the Character Set
9.	CREATE DATABASE statement specifies the character set and collation:
10.	To change the character set to latin1 for the BookSales database, use the following ALTER DATABASE statement
11.	CONVERT( USING )
12.	Check the character set
13.	Check the character set name and description
14.	Character setting for char type column
15.	CHARACTER SET utf8 for column definition
16.	CHARACTER SET 'latin1', CHARACTER SET 'hp8'
17.	Check the character set settings
18.	Check the default character set name
19.	Table with default chartset= latin1;
20.	Set default character during table definition

Specifying the Character Set of a Character String (Cast Operator) : CHARSET « I18N « SQL / MySQL

Related examples in the same category