Utf Quotes

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.

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

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.

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 ;