Laravel 5 - PHP storm - seeder Hebrew

Question

I am trying to seed my DB categories Table with Hebrew content. I can seed my Table with English. can someone please tell me how can I do that?

OK so it is still not working.. I tried using 'utf8_general_ci' and also the "N'אופנה".

There are my files:

database.php

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', 'localhost'),
            'database'  => env('DB_DATABASE', 'forge'),
            'username'  => env('DB_USERNAME', 'forge'),
            'password'  => env('DB_PASSWORD', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_general_ci',
            'prefix'    => '',
            'strict'    => false,
        ]

DatabaseSeeder.php

DB::table('categories')->insert(array(
                array('id' => NULL, 'category_name' => "N'אופנה", 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") ),
                array('id' => NULL, 'category_name' => 'aaa', 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") ),
        ));

database structure

categories structure

categories table

my project encoding

Are you using `forge`? If not. Can you tell me the name of your database? — aldrin27, Sep 06 '15 at 12:50
Yes, it is encoded to UTF-8, you can see below I have posted the current status with pictures — Doron Mor, Sep 06 '15 at 17:14
Please follow the instructions in answer with 9 votes **[HERE](http://stackoverflow.com/questions/5287821/mysql-db-question-marks-instead-of-hebrew-characters)**, you have to be able to store Hebrew characters manualy first, and then try to store them by seeds. — Zakaria Acharki, Sep 06 '15 at 17:19
manually works either way.. but it's like laravel framework shuts it down somehow — Doron Mor, Sep 06 '15 at 17:23

Doron Mor · Accepted Answer · 2015-09-07T19:24:52.433

1

YES I solved the problem !! ok so how to fix that? there you go:

Inside PHP Storm ->

changing the font in "Settings | Appearance | Override default fonts"

looks like the font used by the GUI Theme is not fully unicode

there is the link that I found my answer :)

Hebrew when creating files/projects

Thank you everyone for your time.

edited Sep 07 '15 at 19:24

answered Sep 06 '15 at 17:03

Doron Mor

71
9

aldrin27 · Answer 2 · 2015-09-06T14:46:07.200

If you're not using forge then try this maybe this will work.

Try changing your database to this:

   'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'ibay'),
        'username'  => env('DB_USERNAME', 'root'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ]

Or you could try this if the first didn't work:

     'mysql' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'ibay',
        'username'  => 'root',
        'password'  => '',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ]

In databaseSeeder.php

 return DB::table('categories')->insert(array(
            array('id' => NULL, 'category_name' => 'אופנה', 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") ),
            array('id' => NULL, 'category_name' => 'aaa', 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") )
    ));

In your database schema:

Change your database collation to utf8 collate utf8_general_ci

If the above is not also working try to change your queries to:

 return DB::table('categories')->insert(array(
            array('id' => NULL, 'category_name' => "N'אופנה", 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") ),
            array('id' => NULL, 'category_name' => 'aaa', 'created_at' => date("Y-m-d h:i:s"), 'updated_at' => date("Y-m-d h:i:s") )
    ));

N stands for National language character set. Which means that you are passing an NCHAR, NVARCHAR or NTEXT value

It is still not working.. the 'category_name' stay empty when I'm using Hebrew. — Doron Mor, Sep 06 '15 at 12:59
I am using .env file, but still tried the second option.. its still fill it with empty string :\ — Doron Mor, Sep 06 '15 at 13:04
Its wired becuse I'm able to fill English and all config are for utf-8 — Doron Mor, Sep 06 '15 at 13:05

Laravel 5 - PHP storm - seeder Hebrew

2 Answers2