Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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

/* PRESTASHOP */
/* you could edit the file install/data/db_structure.sql and replace every occurance of */

DEFAULT CHARSET=utf8mb4 COLLATION

/* with */

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

/* then click the restart button and the install works..
but not sure if this has any long term impact on the shop */
Comment

PREVIOUS NEXT
Code Example
Sql :: alter sequence restart with postgresql 
Sql :: set username and password for postgresql database 
Sql :: oracle list tables 
Sql :: generate random data postgresql 
Sql :: how to check database size mysql 
Sql :: mysql date between two dates 
Sql :: import local sql into remote mysql 
Sql :: sql headers delphi 
Sql :: sql beginning of previous month 
Sql :: check message id sql server 
Sql :: show per page table in xampp 
Sql :: dual table in aql 
Sql :: cursor in sql server 
Sql :: how to check even or odd in sql 
Sql :: oracle nls parameters 
Sql :: delete all rows from table mysql 
Sql :: oracle plan hash value 
Sql :: ddl materialized view 
Sql :: install mysql 8 ubuntu 18.04 
Sql :: insert into table from another table mysql 
Sql :: truncate table 
Sql :: check mysql port 
Sql :: replace null with 0 in sql 
Sql :: sql fillna 
Sql :: add timestamp column to existing table ms sql server 
Sql :: how to update column name in psql 
Sql :: oracle ora-00054 resource busy 
Sql :: oracle grant on all tables in schema 
Sql :: t sql check column exists 
Sql :: oracle like case insensitive 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =