Hi everybody,

I can't insert data into Sybase SQL Anywher 8.0 DB properly. I use Lithuanian collation. When I insert only english characters then ewrything is ok. But when I try to insert lithuanian characters, then problem arrises. Data is inserted into DB but lithuanian characters are replased with english ones.

I use simple insert statement and can't see any problem

qry.CommandText = "insert into city (city_nr, city) values(" & nr & ", '" & city & "')"
qry.ExecuteNonQuery()

If I insert data from Sybase Central then everything is ok, but I need to insert data from VB.