Database problem . . . ? ? ? Please i need help

[CorfuVBProgrammer]

--------------------------------------------------------------------------------

Hello all . . .

I have create a database in MySQL Server by using the VB.NET.

The problem is that every time i try to execute an insert query to the database thru the VB.NET the characters that I'm adding in database writen in Greek ar not in Greek but instead Greek characters in the database record I'm getting back question marks for each character (?)

i.e. :

INSERT INTO table(col1, col2, col3) VALUES('val1', '?????', '????????')

in the database I'm getting

cal1 ????? ????????

only if i execute the query from the VB.NET

If i will execute the same query from the MySQL Query Console then is everythink ok.

What can i do for ? ? ?


Thanks a lot . . .

 

[blounty]

Hi there CorfuVBProgrammer,

Have you checked you encoding within vb.net? have a look at this link to see if it sheds any light on your situation.

http://msdn2.microsoft.com/en-us/library/system.text.encoding.aspx

regards

Alex