MySQL: Specified key was too long; max key length is 767 bytes - yanbin's Blog

MySQL: Specified key was too long; max key length is 767 bytes

yanbin posted @ 2016年4月04日 16:50 in 未分类 with tags mysql programming , 2763 阅读

MySQL 使用了InnoDB存儲引擎 UNIQUE index 長度限制是 767 byes; 使用了MyISAM存儲引擎長度限制是 1000 bytes。
使用了 utf-8 字符集兩種引擎下的 vchar 型 UNIQUE index 最大長度分別是 vchar(255) 和 vchar(333),
utf-8 最多使用 3 bytes 表示一個字符: 255 * 3 = 765 ...
使用了 utf-16 字符集兩種引擎下的 vchar 型 UNIQUE index 最大長度分別是 vchar(191) 和 vchar(250)。

django 有時遇到這個問題。
應當懷疑使用了 utf-8 之類的字符集並且 Field(unique=true, max_length=greater_than_255);
或者是否有 unique_together = ['field0', 'field1']; field0_max_length + field1_max_length > 255;

參見:mysql-specified-key-was-too-long-max-key-length-is-767-bytes

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Avatar_small
tv online 说:
2018年5月09日 20:06

tv online 说:
2017年9月20日 21:50

thanks for info

Avatar_small
tv online 说:
2018年5月09日 20:07

tv online 说:
2017年9月20日 21:50

thanks for info

Avatar_small
hotmail login 说:
2018年7月24日 11:19

Interesting post! This is really helpful for me. I like it! Thanks for sharing.

Avatar_small
xbox live membership 说:
2019年5月13日 22:28

get free xbox live codes with this site. It will help you in time of playing.

Avatar_small
geometry dash 说:
2019年5月29日 15:35

I high appreciate this post. It’s hard to find the good from the bad sometimes, but I think you’ve nailed it! would you mind updating your blog with more information?

Avatar_small
카지노사이트 说:
2019年8月01日 15:47

Hmm, I never thought about it that way. I do see your point but I think many will disagree

Avatar_small
mesin gergaji 说:
2019年9月07日 01:10

Interesting post! This is really helpful for me.

Avatar_small
اضرار الزنجبيل 说:
2019年9月14日 15:44

Crucial online marketing you just it applies seek before submission. It will probably be simple and easy to jot down advanced write-up which.

Avatar_small
VIP Financing Soluti 说:
2019年9月23日 05:50

cheers for such a great blog. Where else could anyone get that kind of info written in such a perfect way? I have a presentation that I am presently working on, and I have been on the look out for such info.

Avatar_small
regeneracja turbospr 说:
2019年10月04日 00:11

I love reading your blog because it has very interesting topics.:.:~’

Avatar_small
t rex game 说:
2019年10月17日 12:11

I know your expertise on this. I must say we should have an online discussion on this. Writing only comments will close the discussion straight away! And will restrict the benefits from this information.

Avatar_small
luxury car rental Lo 说:
2019年10月21日 04:14

i think that RSS FEEDS should also be included on the list of the best inventions because it makes life easier for bloggers like us,.

Avatar_small
optica alemana bogot 说:
2019年11月20日 06:09

Thank you for the sensible critique. Me & my cousin were just preparing to do a little research about this. We grabbed a book from our local library but I think I learned more from this post. I am very glad to see such great info being shared freely out there…

Avatar_small
mens black slippers 说:
2019年11月21日 20:32

I’ve been exploring for a little for any high-quality articles or blog posts on this sort of area . Exploring in Yahoo I ultimately stumbled upon this website. Studying this information So i’m satisfied to convey that I’ve a very excellent uncanny feeling I found out exactly what I needed. I most unquestionably will make certain to don’t omit this website and provides it a glance a continuing.

Avatar_small
www.gecey.com/small- 说:
2019年11月22日 15:38

An interesting discussion might be priced at comment. I do believe that you can write much more about this topic, it will not certainly be a taboo subject but generally consumers are there are not enough to dicuss on such topics. An additional. Cheers <a href="https://gecey.com/transparent-monitor/">www.gecey.com/transparent-monitor</a>

Avatar_small
lipolisis laser 说:
2019年12月21日 01:11

Oh my goodness! an excellent article dude. Thank you Nonetheless I will be experiencing trouble with ur rss . Don’t know why Struggling to sign up to it. Perhaps there is any person finding identical rss difficulty? Anyone who knows kindly respond. Thnkx

Avatar_small
jailbreak a Fire Sti 说:
2020年4月22日 03:05

Glad to be one of the visitors on this awe inspiring web site.

Avatar_small
Cupom de Desconto Am 说:
2020年4月27日 13:13

If you are looking for more information about flat rate locksmith Las Vegas check that right away.

Avatar_small
pay njmcdirect surch 说:
2020年4月27日 19:26

This is important, though it's necessary to help you head over to it weblink:

Avatar_small
buy face masks 说:
2020年4月28日 15:21

Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and return to read more of your useful information. Thanks for the post. I will definitely return.

Avatar_small
Aiou 说:
2020年4月29日 03:25

This is my first time i visit here and I found so many interesting stuff in your blog especially it's discussion, thank you.

Avatar_small
شقق للايجار في الريا 说:
2020年5月03日 23:05

I would prescribe my profile is vital to me, I welcome you to examine this subject..

Avatar_small
Barulho de Escritori 说:
2020年5月04日 19:45

This is a fabulous post I seen because of offer it. It is really what I expected to see trust in future you will continue in sharing such a mind boggling post

Avatar_small
mcdonalds satisfacti 说:
2020年5月06日 18:15

Thank you for taking the time to publish this information very useful!

Avatar_small
FoxDose 说:
2020年5月09日 15:47

This is often nice blog post and even i enjoy to enjoy a book it blog post. your site is without a doubt fabulous and you just contain decent office staff ınside your web log. attractive writing continue the good work.

Avatar_small
ymail logiymail 说:
2020年5月11日 23:11

I would prescribe my profile is vital to me, I welcome you to examine this subject..

Avatar_small
best basketball shoe 说:
2020年5月14日 00:14

Nice blog. Found this while searching through

Avatar_small
custom family tree 说:
2020年5月14日 12:22

Assignment help provider works to enhance students’ knowledge and writing skills through their writing services. You don’t have to visit any physical location for buying quality academic writing services.

Avatar_small
cpap filters 说:
2020年5月18日 23:23

I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us

Avatar_small
buy 2k20 mt 说:
2020年5月18日 23:32

I’ve been exploring for a little for any high-quality articles or blog posts on this sort of area . Exploring in Yahoo I ultimately stumbled upon this website. Studying this information So i’m satisfied to convey that I’ve a very excellent uncanny feeling I found out exactly what I needed. I most unquestionably will make certain to don’t omit this website and provides it a glance a continuing.

Avatar_small
La Lluvia 说:
2020年5月21日 01:47

Interesting post! This is really helpful for me. I like it! Thanks for sharing.

Avatar_small
private detectives s 说:
2020年5月21日 19:12

On that website page, you'll see your description, why not read through this.

Avatar_small
house cleaning 说:
2020年5月28日 03:21

Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review. but I can see your viewpoint.

Avatar_small
adilkhatri 说:
2020年5月28日 11:42

Great info! I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have. 코인카지노

Avatar_small
sbobet 说:
2020年5月30日 19:29

This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info:

Avatar_small
rr login 说:
2020年5月31日 17:16

It is perfect time to make some plans for the future and it is time to be happy. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!

Avatar_small
adilkhatri 说:
2020年5月31日 17:28

Incredible post I should state and much obliged for the data. Instruction is unquestionably a sticky subject. Be that as it may, is still among the main themes of our opportunity. I value your post and anticipate more. 바카라사이트

Avatar_small
Private Investigator 说:
2020年5月31日 18:04

i think that RSS FEEDS should also be included on the list of the best inventions because it makes life easier for bloggers like us,.

Avatar_small
office cleaning 说:
2020年6月02日 02:53

I don t have the time at the moment to fully read your site but I have bookmarked it and also add your RSS feeds. I will be back in a day or two. thanks for a great site.

Avatar_small
mshahid 说:
2020年6月04日 20:52

I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.<a href="https://nischenseite-kaufen.com/angebot/">fertige Nischenseite kaufen</a>

Avatar_small
fertige Nischenseite 说:
2020年6月04日 20:53

I will really appreciate the writer's choice for choosing this excellent article appropriate to my matter.Here is deep description about the article matter which helped me more.

Avatar_small
CORPORATE INVESTIGAT 说:
2020年6月12日 04:00

I know your expertise on this. I must say we should have an online discussion on this. Writing only comments will close the discussion straight away! And will restrict the benefits from this information.

Avatar_small
Scrap dealers in uae 说:
2020年6月14日 15:18

This particular is usually apparently essential and moreover outstanding truth along with for sure fair-minded and moreover admittedly useful My business is looking to find in advance designed for this specific useful stuffs…

Avatar_small
custom printed greas 说:
2020年6月15日 21:26

Custom Printed and Branded Products. Branded products leave a lasting impression on your customers and improve their customer experience; we combine design and quality to create bespoke products you can be proud of. At Go for Green we understand that every company’s requirements are different, therefore we maintain as low as possible minimum order quantities on our brandable items trying to ensure you’ll won't have to order more than you need. As specialists in branded products we know that the designing and printing of your food and drink packaging plays an important role in your businesses brand promotion. We ensure that every step in the manufacturing of your product is given the utmost care and attention.We would love to help you bring your vision to life. Low Minimum Order Quantities. UK, European & Far East Manufacturing Options. Express Turnaround. Storage and Fulfilment. Product Sourcing. Please get in touch to discuss your project today.

Avatar_small
mcdonalds breakfast 说:
2020年6月17日 19:54

It’s difficult to get knowledgeable men and women on this topic, but the truth is seem like there’s more you are talking about! Thanks

Avatar_small
rijbewijs kopen 说:
2020年6月23日 05:56

This is what commonly happens to the newbies in the business industry who do not know how to effectively market their product or service or service.

Avatar_small
sec drive 说:
2020年6月24日 15:36

I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more.

Avatar_small
Web Development 说:
2020年11月01日 20:29

The looks definitely splendid. Everyone of these dwarf tips can be fabricated by using lots of records go through. I want everything you need noticeably.

Avatar_small
jordan 说:
2020年12月14日 18:35

You have created a nice blog and I also read some of your posts.free astrology predictions from top astrologers in India as per your Birth Chart.astrology Prediction life report utilizes your birth chart to see what your future life looks like.The birth chart can reveal so many things about you,Talk to astrologer on call or chat, and get the benefits of free astrology services and products with more than 30 years of experiences astrologer online.

Avatar_small
cleaning company dub 说:
2021年8月03日 19:27

This family-owned housecleaning company would be happy and very happy to provide the range about services to adjust to all what you want. We have many, many years of feel in contributing professional local and work cleaning all over the place London. Our fervent and good team brings you superior standard services as being the first head to. We feature End about Tenancy Housecleaning, After Builders Cleaning, Subsequently after Party Housecleaning, One shut off deep housecleaning, Carpet, Type of mattress and Upholstery Housecleaning, Office, Class and Setting, Shop Housecleaning.

Avatar_small
maids in dubai 说:
2021年9月07日 17:49

Regardless of reason, there's no doubt the maid costume is usually as popular since ever. Certainly most of the appeal for the costume arises from the guys who love to see a girl wear it as opposed to from females themselves planning to portray any maid. It's been an important fantasy regarding men around the globe for a long time.

Avatar_small
professional cleanin 说:
2021年9月08日 16:42

In case you are in great must move with a new far better and greater place but is obviously rejecting the theory since you never know in which from to start out packing items, it will be time, you need to call any moving company to have help.


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter
Host by is-Programmer.com | Power by Chito 1.3.3 beta | © 2007 LinuxGem | Design by Matthew "Agent Spork" McGee