character set problem
Posted by: XZeon Zodia
Date: September 18, 2006 09:25AM

im writing a program in VB2005 which uses a database to store usernames & passwords but i get this error:

Character Set 'ascii' Not Supported

When i do this query:

SQL = "SELECT `Users`.`Username`, `Users`.`Password` " _
& "FROM Users " _
& "WHERE BINARY ((`Users`.`Username`= '" & txtun.Text & "')" _
& " AND (`Users`.`Password`= '" & txtpass.Text & "'))"

Can anyone help?



Edited 1 time(s). Last edit at 09/18/2006 09:26AM by XZeon Zodia.

Options: ReplyQuote


Subject
Views
Written By
Posted
character set problem
2318
September 18, 2006 09:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.