How to select from table where table is including åäö characters?
I have set my mysql database, tables and columns to be charset utf8mb4.
I have set the .asp page to have Response.charset="utf-8"
How do write a select where I check if the rs is including åäö characters?
If I use the below and the variable is without åäö then it works, but if the variable contains a word with åäö, then it doesn´t find it!
thepassword="trött"
sql = "SELECT * FROM table where password = '"& thepassword &"' ;"
set rs = conn.Execute (sql)
Any input really appreciated, thanks.
mysql sql vbscript character-encoding asp-classic
edited Nov 11 at 8:24
Lankymart
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
add a comment |
I have set my mysql database, tables and columns to be charset utf8mb4.
I have set the .asp page to have Response.charset="utf-8"
How do write a select where I check if the rs is including åäö characters?
If I use the below and the variable is without åäö then it works, but if the variable contains a word with åäö, then it doesn´t find it!
thepassword="trött"
sql = "SELECT * FROM table where password = '"& thepassword &"' ;"
set rs = conn.Execute (sql)
Any input really appreciated, thanks.
mysql sql vbscript character-encoding asp-classic
edited Nov 11 at 8:24
Lankymart
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
1
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
2
There are other steps you need to check not just settingResponse.Charset = "UTF-8", here is a similar question that should help.
– Lankymart
Nov 11 at 8:28
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54
add a comment |
I have set my mysql database, tables and columns to be charset utf8mb4.
I have set the .asp page to have Response.charset="utf-8"
How do write a select where I check if the rs is including åäö characters?
If I use the below and the variable is without åäö then it works, but if the variable contains a word with åäö, then it doesn´t find it!
thepassword="trött"
sql = "SELECT * FROM table where password = '"& thepassword &"' ;"
set rs = conn.Execute (sql)
Any input really appreciated, thanks.
mysql sql vbscript character-encoding asp-classic
edited Nov 11 at 8:24
Lankymart
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
I have set my mysql database, tables and columns to be charset utf8mb4.
I have set the .asp page to have Response.charset="utf-8"
How do write a select where I check if the rs is including åäö characters?
If I use the below and the variable is without åäö then it works, but if the variable contains a word with åäö, then it doesn´t find it!
thepassword="trött"
sql = "SELECT * FROM table where password = '"& thepassword &"' ;"
set rs = conn.Execute (sql)
Any input really appreciated, thanks.
mysql sql vbscript character-encoding asp-classic
mysql sql vbscript character-encoding asp-classic
edited Nov 11 at 8:24
Lankymart
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
edited Nov 11 at 8:24
Lankymart
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
edited Nov 11 at 8:24
Lankymart
11.5k438100
edited Nov 11 at 8:24
Lankymart
11.5k438100
edited Nov 11 at 8:24
Lankymart
11.5k438100
11.5k438100
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
asked Nov 10 at 17:57
Claes Gustavsson
1,83173759
1,83173759
1
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
2
There are other steps you need to check not just settingResponse.Charset = "UTF-8", here is a similar question that should help.
– Lankymart
Nov 11 at 8:28
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54
add a comment |
1
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
2
There are other steps you need to check not just settingResponse.Charset = "UTF-8", here is a similar question that should help.
– Lankymart
Nov 11 at 8:28
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54
1
1
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
2
2
There are other steps you need to check not just setting
Response.Charset = "UTF-8", here is a similar question that should help.– Lankymart
Nov 11 at 8:28
There are other steps you need to check not just setting
Response.Charset = "UTF-8", here is a similar question that should help.– Lankymart
Nov 11 at 8:28
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54
add a comment |
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%2f53241846%2fhow-to-select-from-table-where-table-is-including-%25c3%25a5%25c3%25a4%25c3%25b6-characters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53241846%2fhow-to-select-from-table-where-table-is-including-%25c3%25a5%25c3%25a4%25c3%25b6-characters%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
1
Using parameterized queries might help you with that as the SQL engine takes care of escaping certain characters and properly preparing the query for you. See: How do I create a parameterized SQL query? Why Should I?
– Visual Vincent
Nov 10 at 18:27
2
There are other steps you need to check not just setting
Response.Charset = "UTF-8", here is a similar question that should help.– Lankymart
Nov 11 at 8:28
Thanks, I got it working in the end :-)
– Claes Gustavsson
Nov 14 at 13:54