Sir,
i am using using vb6 and mysql. i am using vb6 to enter datas to mysql database. my problem is i can't insert unicode text to mysql database. i am using microsoft form control's text box to enter unicode (vb6's textbox doesnot support unicode. isn't it?) when i insert textbox contents to mysql database it shows only question marks. please help me.... below is my code.....

Set conn = New ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=localhost;" _
& "DATABASE=2007_news;" _
& "UID=root;" _
& "PWD=;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
conn.ConnectionString = GloConnectionString
conn.CursorLocation = adUseClient
conn.Open
rs.Open "INSERT INTO news (news_id, news_content) values(100, '" & TextBox1.Text & "')", conn
conn.Close


raman