Can't insert arabic text into mysql database using mysql prompt

1 vote

2 answers

6313 views

mysql mysqldump command-line utf-8 mysqli

                          I had a local table with arabic values.when exported i got the following query.

    DROP TABLE IF EXISTS type;
     CREATE TABLE IF NOT EXISTS type (
     bs_id int(11) NOT NULL AUTO_INCREMENT,
     types varchar(250) NOT NULL,
      PRIMARY KEY (bs_id)
     ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

    -- 
    -- Data for table business_type
    -- 

    INSERT INTO type (bs_id, types) VALUES
     ('1', 'صناعة'),
     ('2', 'معارض'),
     ('3', 'أسواق'),
     ('4', 'إستيراد وتوزيع'),
     ('5', 'خدمات'),
     ('6', 'إستشارات'),
     ('7', 'أخرى');

I want to create this table on server so i just copied the above query and run it on server terminal.The query works fine but the values in table is showing like ".....".

tried this

     SET NAMES utf8;

 before inserting the values,but failed.I don't have a cpanel installed on server.Command prompt is the only option.

Can anyone help!!

Thanks
                        

Asked by AVM (141 rep)

Jan 1, 2015, 07:36 PM
Last activity: Jul 26, 2024, 03:57 AM

Can't insert arabic text into mysql database using mysql prompt

Related Questions