ASP/Unicode Question
I'm currently Developing an application that’s going to be used in Scotland and I'm running into an issue I think is related to Unicode.
I have a simple form (username/passcode) which is being submitted. My database that stores this information is SQL (ASCII/varchar data fields). Now, I'm having my code capture the information a user submits before it's processed, just so i can double check any issues that might come up.
Several users are saying they're not able to log in. The DB is reporting that it couldn't find their Username/Passcode, but when I attempt to log in using the information I captured, it worked. I've checked the error logs and it is in fact not finding the information in the DB, even though the information was entered correctly.
I think it's an issue with Unicode/ASCII support in ASP and SQL. Like SQL is running the query with the Unicode Data the page passed against the ASCII values in the DB and it's returning nothing.
My question is has anyone here delt with International Browsers and unicode before with a project developed using Microsoft products (ASP/SQL). What issues did you run into? Am I on the right track here or what?
*grubmle*
I have a simple form (username/passcode) which is being submitted. My database that stores this information is SQL (ASCII/varchar data fields). Now, I'm having my code capture the information a user submits before it's processed, just so i can double check any issues that might come up.
Several users are saying they're not able to log in. The DB is reporting that it couldn't find their Username/Passcode, but when I attempt to log in using the information I captured, it worked. I've checked the error logs and it is in fact not finding the information in the DB, even though the information was entered correctly.
I think it's an issue with Unicode/ASCII support in ASP and SQL. Like SQL is running the query with the Unicode Data the page passed against the ASCII values in the DB and it's returning nothing.
My question is has anyone here delt with International Browsers and unicode before with a project developed using Microsoft products (ASP/SQL). What issues did you run into? Am I on the right track here or what?
*grubmle*
