| chobblr |
|
|---|---|
|
i have been following the steps using the video tutorial supplied on here, i am currently on #6 and just imported my SQL but i get this error message
"1253 - COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'" any help in solving this would be great thanks |
| Lombi |
|
|---|---|
|
Please refer back to the part of the tutorial #4 where I do a replace of latin1 with utf8.
It's explained in this tutorial at 1:15: http://www.cotonti.com/docs/en/upgradevideos/notepad_encoding_utf8_bom Also search for other occurances of latin1. Are there any left? <a href="http://www.domenlo.com">Surreal Art</a>
|
| chobblr |
|
|---|---|
|
i did do that, the part the error is re-framing to is this "COLLATE=latin1_general_ci AUTO_INCREMENT=569 ;" do i need to change ALL the latin1 even these parts ?
|
| Lombi |
|
|---|---|
|
Yes, just replace it with utf8_general_ci
<a href="http://www.domenlo.com">Surreal Art</a>
|
| chobblr |
|
|---|---|
|
thank you, will be trying that now
UPDATE: thanks it just changed 165 total |
|
| This post was edited by chobblr (2009-05-08 00:15, 15 years ago) |
| Lombi |
|
|---|---|
|
Let us know how it goes.
<a href="http://www.domenlo.com">Surreal Art</a>
|
| chobblr |
|
|---|---|
|
it works, great !! i have a question i have a subdomain that users will get diverted to it uses the same Database and that lot, if i just do the same step where i move the files in, will it all work still
|
| Lombi |
|
|---|---|
|
It should.
<a href="http://www.domenlo.com">Surreal Art</a>
|
