কম্পিউটার টিউটোরিয়াল

MySQL দ্বারা সমর্থিত সকল ক্যারেক্টার সেট জানার কোয়ারিটি কী?


নিচের কোয়ারিটি ব্যবহার করে MySQL দ্বারা সমর্থিত সকল ক্যারেক্টার সেট দেখা যায় −

mysql> Show Character Set; +-----------+-----------------------------+---------------------+--------+ | Charset   | Description                 | Default collation   | Maxlen | +-----------+-----------------------------+---------------------+--------+ | big5      | Big5 Traditional Chinese    | big5_chinese_ci     | 2      | | dec8      | DEC West European           | dec8_swedish_ci     | 1      | | cp850     | DOS West European           | cp850_general_ci    | 1      | | hp8       | HP West European            | hp8_english_ci      | 1      | | koi8r     | KOI8-R Relcom Russian       | koi8r_general_ci    | 1      | | latin1    | cp1252 West European        | latin1_swedish_ci   | 1      | | latin2    | ISO 8859-2 Central European | latin2_general_ci   | 1      | | swe7      | 7bit Swedish                | swe7_swedish_ci     | 1      | | ascii     | US ASCII                    | ascii_general_ci    | 1      | | ujis      | EUC-JP Japanese             | ujis_japanese_ci    | 3      | | sjis      | Shift-JIS Japanese          | sjis_japanese_ci    | 2      | | hebrew    | ISO 8859-8 Hebrew           | hebrew_general_ci   | 1      | | tis620    | TIS620 Thai                 | tis620_thai_ci      | 1      | | euckr     | EUC-KR Korean               | euckr_korean_ci     | 2      | | koi8u     | KOI8-U Ukrainian            | koi8u_general_ci    | 1      | | gb2312    | GB2312 Simplified Chinese   | gb2312_chinese_ci   | 2      | | greek     | ISO 8859-7 Greek            | greek_general_ci    | 1      | | cp1250    | Windows Central European    | cp1250_general_ci   | 1      | | gbk       | GBK Simplified Chinese      | gbk_chinese_ci      | 2      | | latin5    | ISO 8859-9 Turkish          | latin5_turkish_ci   | 1      | | armscii8  | ARMSCII-8 Armenian          | armscii8_general_ci | 1      | | utf8      | UTF-8 Unicode               | utf8_general_ci     | 3      | | ucs2      | UCS-2 Unicode               | ucs2_general_ci     | 2      | | cp866     | DOS Russian                 | cp866_general_ci    | 1      | | keybcs2   | DOS Kamenicky Czech-Slovak  | keybcs2_general_ci  | 1      | | macce     | Mac Central European        | macce_general_ci    | 1      | | macroman  | Mac West European           | macroman_general_ci | 1      | | cp852     | DOS Central European        | cp852_general_ci    | 1      | | latin7    | ISO 8859-13 Baltic          | latin7_general_ci   | 1      | | utf8mb4   | UTF-8 Unicode               | utf8mb4_general_ci  | 4      | | cp1251    | Windows Cyrillic            | cp1251_general_ci   | 1      | | utf16     | UTF-16 Unicode              | utf16_general_ci    | 4      | | cp1256    | Windows Arabic              | cp1256_general_ci   | 1      | | cp1257    | Windows Baltic              | cp1257_general_ci   | 1      | | utf32     | UTF-32 Unicode              | utf32_general_ci    | 4      | | binary    | Binary pseudo charset       | binary              | 1      | | geostd8   | GEOSTD8 Georgian            | geostd8_general_ci  | 1      | | cp932     | SJIS for Windows Japanese   | cp932_japanese_ci   | 2      | | eucjpms   | UJIS for Windows Japanese   | eucjpms_japanese_ci | 3      | +-----------+-----------------------------+---------------------+--------+ 39 rows in set (0.14 sec)

  1. MySQL কোয়েরিতে স্ল্যাশ (/) এর অর্থ — ভাগ করা

  2. MySQL-এ LIKE দিয়ে % (পারসেন্ট) ক্যারেক্টার সম্বলিত রেকর্ড খোঁজা

  3. MySQL에서 데이터베이스의 테이블 개수 조회하기

  4. MySQL কোন প্ল্যাটফর্মগুলো সাপোর্ট করে?