Timeline for Error 1005: Can't create table can't find where the problem is
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 11:33 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Feb 27, 2014 at 14:24 | comment | added | ReynierPM |
@ypercube add the CHARACTER SET and COLLATE in all tables fix the problem, thanks all of yours
|
|
| Feb 27, 2014 at 14:23 | vote | accept | ReynierPM | ||
| Feb 27, 2014 at 14:20 | history | edited | ReynierPM | CC BY-SA 3.0 |
added 1065 characters in body
|
| Feb 27, 2014 at 14:19 | comment | added | Nathan Jolly |
@ypercube is spot on - either add that to the definition of tb_order or consider changing the beginning of your script to CREATE SCHEMA IF NOT EXISTS portal_de_logistica DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
|
|
| Feb 27, 2014 at 14:18 | comment | added | ypercubeᵀᴹ | So you skipped step 6 from that link: "6. Make sure that the Charset and Collate options are the same both at the table level as well as individual field level for the key columns." | |
| Feb 27, 2014 at 14:15 | answer | added | Up_One | timeline score: 3 | |
| Feb 27, 2014 at 14:07 | comment | added | ypercubeᵀᴹ |
You don't have DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci in all the tables.
|
|
| Feb 27, 2014 at 14:00 | history | asked | ReynierPM | CC BY-SA 3.0 |