Ask a Question related to ASP Database, Design and Development.
-
Mohamed Hosam #1
MySQL and foreign languages
I don't know if someone has faced this.. I have a web site where people
register and login. 90% of visitors register with Arabic usernames. When
users became so many, MySQL started to do something weird.
When users login, I simply perform "select ID from musers where username =
'" & username & "' and pwd = '" & pwd & "'" to check login information..
What is weird is that this statement started to get more than one result
sometimes (if password is the same) although usernames are different! I used
to use LIKE but when this happened, I used = but still the same result.
Any idea why this is happening? Although usernames are different, MySQL gets
usernames that are similar (in a way that I could not find out)! Is there a
way to overcome this?
Regards,
Mohamed
Mohamed Hosam Guest
-
Special characters in foreign languages
I am rewriting a page in Spanish and cannot find code within Dreamweaver for special characters: tilde, accent marks, inverted question and... -
text in foreign languages
I have a version of Illustrator 10 that I used to design a card game. I would like to change the text in my card game to a non roman foreign... -
Foreign Languages
Hello: I am building a Slideshow using an xml file and the titles of each slide are in text nodes of the file. I want these string of text in... -
Microsoft Access & Foreign Languages
I am writing an sites for mulitple languages, even though in the script I tell the encoding type to be for the language in Microsoft Access it... -
how do you create foreign key constraints in mySQL? Or Close to it?
create table if not exists nnet_produkt_varegruppe ( nnet_produkt_varegruppe_id int not null auto_increment, primary... -
Sylvain Lafontaine #2 Re: MySQL and foreign languages
MySQL must be installed as a UNICODE instance to be able to dealt correctly
with Unicode:
[url]http://www.mysql.com/documentation/maxdb/13/7e05c2acfead44ade8183219051298/content.htm[/url]
Otherwise, \0 byte inside unicode strings will be seen as the Null byte or
End of String character or something like that.
S. L.
"Mohamed Hosam" <info@internetplus.biz> wrote in message
news:OR0kXbbwDHA.2440@TK2MSFTNGP12.phx.gbl...used> I don't know if someone has faced this.. I have a web site where people
> register and login. 90% of visitors register with Arabic usernames. When
> users became so many, MySQL started to do something weird.
>
> When users login, I simply perform "select ID from musers where username =
> '" & username & "' and pwd = '" & pwd & "'" to check login information..
>
> What is weird is that this statement started to get more than one result
> sometimes (if password is the same) although usernames are different! Igets> to use LIKE but when this happened, I used = but still the same result.
>
> Any idea why this is happening? Although usernames are different, MySQLa> usernames that are similar (in a way that I could not find out)! Is there> way to overcome this?
>
> Regards,
> Mohamed
>
>
Sylvain Lafontaine Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
