Hebrew in MySQL

------=_NextPart_000_0003_01C608DB.80C60940
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello

I have some problem with using MySql with hebrew charasters in tables (data
string) to view it in VB6

The problem is I send SQL select string and I got '??????????' charasters
from MYSQL

Please help !!!

Some code

Dim a as adodb.connection

a.open CONNECTION_STRING

set rec=a.execute("select * from place")



in rec variable I got fields ,the field with hebrew text given to me like
'???????????'

Thanks at all Simon


------=_NextPart_000_0003_01C608DB.80C60940--