I have SQL Server Database configured for Greek.
Table1 has Column1 type varchar(50)
Some string is stored in Greek Code Page
Example first 3 bytes are
I run this from computer with English United States Regional Setting from
Const conn = "Provider=SQLOLEDB.1;Persist Security Info=False;Network
Dim cmd As New ADODB.Command, Rs As ADODB.Recordset
Dim i As Integer
.ActiveConnection = conn
.CommandType = adCmdText
.CommandText = "select Column1 from Table1 where UniqueID = 1"
Set Rs = .Execute
And getting some garbage in the result.
I'd expect the worst case scenario of results as bytes sequence
Since Strings in VB are Unicode 2 bytes.
Instead I get something like
I do not understand where 54 came from.
How to tell SQL Server 2000 in connection string or anywhere else that I
need result converted to Unicode using Greek
or at least get some reasonable result.
Any idea is appreciated.
Software Developer & Consultant
Minds are like parachutes - they only function when open.