How to select from table where table is including åäö characters?
up vote
0
down vote
favorite
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.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
add a comment |
up vote
0
down vote
favorite
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.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
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.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
edited Nov 11 at 8:24
Lankymart
11.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
edited Nov 11 at 8:24
Lankymart
11.4k43897
edited Nov 11 at 8:24
Lankymart
11.4k43897
edited Nov 11 at 8:24
Lankymart
11.4k43897
11.4k43897
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
asked Nov 10 at 17:57
Claes Gustavsson
1,79873759
1,79873759
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
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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