Magento 2 change database collation The 2019 Stack Overflow Developer Survey Results Are InHow to completely delete EAV attribute and all its data from the database?Magento Database Separationwhat and all is attribute code in following codeDelete category attribute from the databaseRestoring related products from database back upWhat would cause the wrong attributes to display after Magento 2 migation?Magento 2 Where (code) are the filters from the layered navigation applied to the product collection?Filters and results not working properlyMagento 2.2.6 products not rendering on frontend after migrationMagento 2.3 Layered Navigation Returns all Products, unfiltered
What do the Banks children have against barley water?
The difference between dialogue marks
Are USB sockets on wall outlets live all the time, even when the switch is off?
What does "rabbited" mean/imply in this sentence?
Any good smartcontract for "business calendar" oracles?
I see my dog run
Why isn't airport relocation done gradually?
How can I fix this gap between bookcases I made?
Could JWST stay at L2 "forever"?
Inline version of a function returns different value then non-inline version
"To split hairs" vs "To be pedantic"
Inflated grade on resume at previous job, might former employer tell new employer?
Limit the amount of RAM Mathematica may access?
Where to refill my bottle in India?
Does light intensity oscillate really fast since it is a wave?
How to manage monthly salary
Why can Shazam do this?
How to reverse every other sublist of a list?
How long do I have to send payment?
It's possible to achieve negative score?
What is the meaning of Triage in Cybersec world?
I looked up a future colleague on LinkedIn before I started a job. I told my colleague about it and he seemed surprised. Should I apologize?
Is flight data recorder erased after every flight?
Lethal sonic weapons
Magento 2 change database collation
The 2019 Stack Overflow Developer Survey Results Are InHow to completely delete EAV attribute and all its data from the database?Magento Database Separationwhat and all is attribute code in following codeDelete category attribute from the databaseRestoring related products from database back upWhat would cause the wrong attributes to display after Magento 2 migation?Magento 2 Where (code) are the filters from the layered navigation applied to the product collection?Filters and results not working properlyMagento 2.2.6 products not rendering on frontend after migrationMagento 2.3 Layered Navigation Returns all Products, unfiltered
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am wondering if it is safe to change a magento database collation
from utf-8 general_ci to utf-8 unicode_ci.
I can do it from phpmyadmin or directly in mysql...
I just don't know if it is safe for magento. Will it work after or will create problems?
The reason I want to do this is that I am having some strange problems.
For example after migration from magento 1 I noticed that some attributes didn't appeared in layered navigation although they was filtered with results.
With further examination in database the attributes were fine and set in the products. But magento in frond end returned them empty so empty filter not appears in layered.
I am using two different store views. Two languages. So when I resaved a product in admin without changing anything then filters with attributes appeared in layered. This didn't happened with all filters. Just with those which didn't worked.
This happened with magento 2.3 version. Fixed with a script I made and resaved all products in all store views...This fixed the whole catalog filters.
But now when upgrade to 2.3.1 I lost in frontend from some products the custom options. All products in admin had custom option but in frontend didn't appeared.
When resaved the products everything came up again.
So I don't have a clue why this is happening and I thinking to change database collation.
Anybody has ideas please?
magento2 database migration
add a comment |
I am wondering if it is safe to change a magento database collation
from utf-8 general_ci to utf-8 unicode_ci.
I can do it from phpmyadmin or directly in mysql...
I just don't know if it is safe for magento. Will it work after or will create problems?
The reason I want to do this is that I am having some strange problems.
For example after migration from magento 1 I noticed that some attributes didn't appeared in layered navigation although they was filtered with results.
With further examination in database the attributes were fine and set in the products. But magento in frond end returned them empty so empty filter not appears in layered.
I am using two different store views. Two languages. So when I resaved a product in admin without changing anything then filters with attributes appeared in layered. This didn't happened with all filters. Just with those which didn't worked.
This happened with magento 2.3 version. Fixed with a script I made and resaved all products in all store views...This fixed the whole catalog filters.
But now when upgrade to 2.3.1 I lost in frontend from some products the custom options. All products in admin had custom option but in frontend didn't appeared.
When resaved the products everything came up again.
So I don't have a clue why this is happening and I thinking to change database collation.
Anybody has ideas please?
magento2 database migration
add a comment |
I am wondering if it is safe to change a magento database collation
from utf-8 general_ci to utf-8 unicode_ci.
I can do it from phpmyadmin or directly in mysql...
I just don't know if it is safe for magento. Will it work after or will create problems?
The reason I want to do this is that I am having some strange problems.
For example after migration from magento 1 I noticed that some attributes didn't appeared in layered navigation although they was filtered with results.
With further examination in database the attributes were fine and set in the products. But magento in frond end returned them empty so empty filter not appears in layered.
I am using two different store views. Two languages. So when I resaved a product in admin without changing anything then filters with attributes appeared in layered. This didn't happened with all filters. Just with those which didn't worked.
This happened with magento 2.3 version. Fixed with a script I made and resaved all products in all store views...This fixed the whole catalog filters.
But now when upgrade to 2.3.1 I lost in frontend from some products the custom options. All products in admin had custom option but in frontend didn't appeared.
When resaved the products everything came up again.
So I don't have a clue why this is happening and I thinking to change database collation.
Anybody has ideas please?
magento2 database migration
I am wondering if it is safe to change a magento database collation
from utf-8 general_ci to utf-8 unicode_ci.
I can do it from phpmyadmin or directly in mysql...
I just don't know if it is safe for magento. Will it work after or will create problems?
The reason I want to do this is that I am having some strange problems.
For example after migration from magento 1 I noticed that some attributes didn't appeared in layered navigation although they was filtered with results.
With further examination in database the attributes were fine and set in the products. But magento in frond end returned them empty so empty filter not appears in layered.
I am using two different store views. Two languages. So when I resaved a product in admin without changing anything then filters with attributes appeared in layered. This didn't happened with all filters. Just with those which didn't worked.
This happened with magento 2.3 version. Fixed with a script I made and resaved all products in all store views...This fixed the whole catalog filters.
But now when upgrade to 2.3.1 I lost in frontend from some products the custom options. All products in admin had custom option but in frontend didn't appeared.
When resaved the products everything came up again.
So I don't have a clue why this is happening and I thinking to change database collation.
Anybody has ideas please?
magento2 database migration
magento2 database migration
asked 5 hours ago
G. G.G. G.
809
809
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f269434%2fmagento-2-change-database-collation%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f269434%2fmagento-2-change-database-collation%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown