Mixing
how to change column collation type in sql?
ALTER TABLE test ALTER COLUMN name CONVERT TO CHARACTER SET utf8 COLLATe utf8_general_ci
I want one of the column to be multilingual, so i changed collation type to utf8_general_ci in database. Its accepting multilingual data and displaying in web app. But when in mobile, multilingual column value is displaying as "??????" (question marks). I tried to encode column data by above query but query is not getting executed. Kindly let me know how to send multilingual column in API .
android sql api collation edited Nov 22 '18 at 10:49
bhupathi turaga
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
add a comment |
ALTER TABLE test ALTER COLUMN name CONVERT TO CHARACTER SET utf8 COLLATe utf8_general_ci
I want one of the column to be multilingual, so i changed collation type to utf8_general_ci in database. Its accepting multilingual data and displaying in web app. But when in mobile, multilingual column value is displaying as "??????" (question marks). I tried to encode column data by above query but query is not getting executed. Kindly let me know how to send multilingual column in API .
android sql api collation edited Nov 22 '18 at 10:49
bhupathi turaga
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06
add a comment |
ALTER TABLE test ALTER COLUMN name CONVERT TO CHARACTER SET utf8 COLLATe utf8_general_ci
I want one of the column to be multilingual, so i changed collation type to utf8_general_ci in database. Its accepting multilingual data and displaying in web app. But when in mobile, multilingual column value is displaying as "??????" (question marks). I tried to encode column data by above query but query is not getting executed. Kindly let me know how to send multilingual column in API .
android sql api collation edited Nov 22 '18 at 10:49
bhupathi turaga
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
ALTER TABLE test ALTER COLUMN name CONVERT TO CHARACTER SET utf8 COLLATe utf8_general_ci
I want one of the column to be multilingual, so i changed collation type to utf8_general_ci in database. Its accepting multilingual data and displaying in web app. But when in mobile, multilingual column value is displaying as "??????" (question marks). I tried to encode column data by above query but query is not getting executed. Kindly let me know how to send multilingual column in API .
android sql api collation android sql api collation edited Nov 22 '18 at 10:49
bhupathi turaga
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
edited Nov 22 '18 at 10:49
bhupathi turaga
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
edited Nov 22 '18 at 10:49
bhupathi turaga
14312
edited Nov 22 '18 at 10:49
bhupathi turaga
14312
edited Nov 22 '18 at 10:49
bhupathi turaga
14312
14312
asked Nov 22 '18 at 10:42
vaishuvaishu
14
asked Nov 22 '18 at 10:42
vaishuvaishu
14
asked Nov 22 '18 at 10:42
vaishuvaishu
14
14
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06
add a comment |
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53429124%2fhow-to-change-column-collation-type-in-sql%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 Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f53429124%2fhow-to-change-column-collation-type-in-sql%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
You must set the character collation 2x. In the database structure and when connected. Here is example for MySQL: dev.mysql.com/doc/refman/8.0/en/charset-connection.html
– bato3
Nov 22 '18 at 11:06