Charset Test

Test 1: Trying Different Charsets

A. With utf8:

Arabic Name	English Name
Ø®ØµØ§Ø¦Øµ Ø¹Ø§Ù…Ù‡
Ø§Ù„Ù‚Ø§Ø¦Ù…Ù‡
Ø§Ø¹Ø¯Ø§Ø¯Ø§Øª Ø§Ù„Ù…Ù†ØªØ¬
Ù…Ø¬Ù…ÙˆØ¹Ø§Øª Ø§Ù„Ù…Ø³ØªØ®Ø¯Ù…ÙŠÙ†
Ø§Ù„Ù…Ø³ØªØ®Ø¯Ù…ÙŠÙ†

B. With utf8mb4:

Arabic Name	English Name
Ø®ØµØ§Ø¦Øµ Ø¹Ø§Ù…Ù‡
Ø§Ù„Ù‚Ø§Ø¦Ù…Ù‡
Ø§Ø¹Ø¯Ø§Ø¯Ø§Øª Ø§Ù„Ù…Ù†ØªØ¬
Ù…Ø¬Ù…ÙˆØ¹Ø§Øª Ø§Ù„Ù…Ø³ØªØ®Ø¯Ù…ÙŠÙ†
Ø§Ù„Ù…Ø³ØªØ®Ø¯Ù…ÙŠÙ†

C. With latin1 (raw bytes):

Arabic Name	English Name
خصائص عامه
القائمه
اعدادات المنتج
مجموعات المستخدمين
المستخدمين

Test 2: Database Charset Settings

Variable	Value
character_set_client	latin1
character_set_connection	latin1
character_set_database	latin1
character_set_filesystem	binary
character_set_results	latin1
character_set_server	latin1
character_set_system	utf8mb3
character_sets_dir	/usr/share/mysql/charsets/

Test 3: Properties Table Charset

Collation: utf8mb3_general_ci

Test 4: Column Charset

Array
(
    [Field] => propertyname
    [Type] => varchar(255)
    [Collation] => utf8mb3_general_ci
    [Null] => NO
    [Key] => 
    [Default] => 
    [Extra] => 
    [Privileges] => select,insert,update,references
    [Comment] => 
)