Utf8 Quotes

CREATE TABLE IF NOT EXISTS 'users' (   'id' int(10) unsigned NOT NULL AUTO_INCREMENT,   'username' varchar(255) COLLATE utf8_unicode_ci NOT NULL,   'password' varchar(255) COLLATE utf8_unicode_ci NOT NULL,   'email' varchar(255) COLLATE utf8_unicode_ci NOT NULL,   'phone' varchar(255) COLLATE utf8_unicode_ci NOT NULL,   'name' varchar(255) COLLATE utf8_unicode_ci NOT NULL,   'created_at' timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',   'updated_at' timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',   PRIMARY KEY ('id') ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

byte[] utf8Bytes  = System.Text.Encoding.UTF8.GetBytes    ("0123456789"); byte[] utf16Bytes = System.Text.Encoding.Unicode.GetBytes ("0123456789"); byte[] utf32Bytes = System.Text.Encoding.UTF32.GetBytes   ("0123456789"); Console.WriteLine (utf8Bytes.Length);    // 10 Console.WriteLine (utf16Bytes.Length);   // 20 Console.WriteLine (utf32Bytes.Length);   // 40

To make sure your strings go from PHP to MySQL as UTF-8, make sure your database and tables are all set to the utf8mb4 character set and collation, and that you use the utf8mb4 character set in the PDO connection string.

In an ideal world, the only character encoding (or, loosely, “character set”) that you’d ever see would be UTF-8 (utf-8), and Latin-1 (iso-8859-1) for all those legacy documents. However, the encodings mentioned below exist and can be found on the Web.