I'm reading text data from an Access database 2003 through ADO 2.8 in a VB 6 application. I don't know if the data read is unicode or not, but I think so.
The problem is that when see the data opening the DB in Access it is shown some way, but when it is shown in a list box, for example, in VB 6, it is shown modified.
Since I used the value shown on screen to update data in the database (in order to replace it for a valid one selected from a different list), the UPDATE SQL statement, does not modify any record, because it can't find one record with the data as it is shown on screen. Which is logical, since data, as I already said, is shown modified on screen.
If I replace the standard VB6 list box for the Microsoft Form 2.0 list box, some characters are still shown different, while other are shown exactly as I can see them by opening the DB from Access. The point is that using this control, the SQL statements works perfect always.
To make things more complicated, if I print on Debug window the SQL statement that will be executed (using the value shown on screen on a MS Forms 2.0 listbox), it shows incorrect values but it runs perfectly and modifies the right records on the DB.
For instance: opening the DB from Acess I see: "American Airlines Divisidn Servicios Aeroportuarios SA", which is shown as "American Airlines Divisi|n Servicios Aeroportuarios SA" on screen, but shown as "American Airlines Divisi=n Servicios Aeroportuarios SA" on the SQL string (if it is printed in the Debug window).
1) Could someone tell me what's happening here?
2) Is there any way that the value that I see in Access could be shown exactly the same on the screen?
3) What can be causing that despite the fact that values are being shown and printed incorrectly they are working as they should be, when executed on an SQL statement?
4) How can I know if data is unicode data?
Start Free Trial
