Error SQL first installation PS 8.1.0 - The maximum column size is 767 bytes

[Ronald72]

Hello,

Already problèmes to go to 8.1.0 from a 1.7.8.6 version so I try a new installation but got this error

Citation

 

Une erreur est survenue durant l'installation...

1: 0

"Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes."

 

But my date base seem to be correct ?

any one can help me on this one ?

Thanks,

Ronald

 

Edited July 16, 2023 by Ronald72 (see edit history)

[musicmaster]

This is about the size of an index for which Mysql has a maximum. When you change the character encoding (utf8_general - utf8mb4_general - utf8mb4_unicode) you increase the (maximum) number of bytes per character. 

This has been a prior problem too. In PS 1.7 some database VARCHAR field sizes are 191 where they were 255 in PS 1.6 for the same reason.

You  can read more about this error here:

https://stackoverflow.com/questions/1814532/mysql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes