Posted inLaravel / php

How To Fix Laravel Specified Key Was Too Long Error?

Today, We want to share with you specified key was too long laravel.In this post we will show you laravel 5.8 database string max length, hear for specified key was too long laravel 5.8 migration we will give you demo and example for implement.In this post, we will learn about Laravel Interview Questions with an example.

specified key was too long laravel

There are the Following The simple About 1071 Specified key was too long; max key length is 767 bytes Full Information With Example and source code.

As I will cover this Post with live Working example to develop laravel 5.8 specified key was too long error, so the syntax error or access violation 1071 specified key was too long laravel 5.8 is used for this example is following below.

“Specified key was too long error”

Just tomorrow We were installing laravel latest version and simple run migration at that time We got identify key was too long error in migration. you can display it was same error bellow some message:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))

[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

“AppServiceProvider.php” under the app/Provider directory.

public function boot()
{
    Schema::defaultStringLength(191);
}

bellow code on service provider file:


Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about specified key was too long laravel.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

Your email address will not be published. Required fields are marked *

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype