Ugh, that seems quite right. Now, why did they do that?
It was added for compatibility.
A separate specification is less convenient, and also less transparent.
Please click "affects me" on http://bugs.mysql.com/bug.php?id=47771
- Morgan
--
MySQL General Mailing List
For list archives: ht
2014/01/06 14:24 -0500, Morgan Tocker
You might be hitting:
"Important
The inline REFERENCES specifications where the references are defined as part
of the column specification are silently ignored. MySQL only accepts REFERENCES
clauses defined as part of a separate FOREIGN KEY specifi
Am 06.01.2014 18:21, schrieb h...@tbbs.net:
> Are INNODB foreign-key references ignored in 5.6?
why should they?
http://www.catb.org/~esr/faqs/smart-questions.html#beprecise
signature.asc
Description: OpenPGP digital signature
On 1/6/2014, 12:21 PM, h...@tbbs.net wrote:
Are INNODB foreign-key references ignored in 5.6?
You might be hitting:
"Important
The inline REFERENCES specifications where the references are defined as
part of the column specification are silently ignored. MySQL only
accepts REFERENCES clauses
Sven
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 10. Februar 2004 15:29
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]
> Subject: Re: Foreign Key Reference to a VARCHAR
>
> Heikki Tuuri wrote:
> >
> > I guess that 4
Heikki Tuuri wrote:
I guess that 4-byte UTF8 characters are not needed. You can code 16 million
characters with 3 bytes.
Yes. But is that also the case if you use the UTF-8 encoding
scheme, or can that scheme code less characters with 3 bytes?
http://ln.hixie.ch/?start=1064324988&order=-1&count=1
languages on Earth.
Thank you,
Heikki
- Alkuperäinen viesti -
Lähettäjä: "Sven Woltmann" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Lähetetty: Tuesday, February 10, 2004 3:53 PM
Aihe: RE: Foreign Key Reference
ks again,
Sven
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 10. Februar 2004 14:19
> To: [EMAIL PROTECTED]
> Subject: Re: Foreign Key Reference to a VARCHAR
>
> Sven,
>
> are you using the UTF8 charset? Then a single chara
Sven,
are you using the UTF8 charset? Then a single character may use up to 3
bytes. Since MySQL cannot work with index columns longer than 255 bytes, for
columns CHAR(86) or longer, MySQL must define a 'column prefix' index, if
you define an index on the column. That is, MySQL internally creates
