AdrianBuzgau
August 19th, 1999, 07:30 PM
Hi all,
The problem:
I am trying to copy data from a MS Access 2000 database to a SQL 7.0 database with VB 6.0. The data in the MS Access database is multi lingual that is the text fields are unicode. When I create the recordset for the table in Access I looze the unicode characters. They turn into "?" and are displayed on SQL as "?".
The question:
Is there a way to copy unicode data with VB 6.0 without loosing the unicode characters?
Is VB the tool for this or should I switch over to VC?
The solution:
Please fill in if you have any idea....
The problem:
I am trying to copy data from a MS Access 2000 database to a SQL 7.0 database with VB 6.0. The data in the MS Access database is multi lingual that is the text fields are unicode. When I create the recordset for the table in Access I looze the unicode characters. They turn into "?" and are displayed on SQL as "?".
The question:
Is there a way to copy unicode data with VB 6.0 without loosing the unicode characters?
Is VB the tool for this or should I switch over to VC?
The solution:
Please fill in if you have any idea....