B4J Question ucanaccess & Access 97 & special characters

[Pesciolina]

Hi,
I need to connect to an old Access 97 database and I'm having problems with special characters.
This is the call to the database.

AccDB.Initialize2(     "net.ucanaccess.jdbc.UcanaccessDriver", _
                            "jdbc:ucanaccess://" & AccDBPath & _
                            ";memory=true;showSchema=true;openExclusive=false;charSet=Windows-1252;immediatelyReleaseResources=true", _
                            "", sDBpass)


    Dim Query As String = "SELECT * from Manifestazioni "
        
    Dim DBResultSet As ResultSet = AccDB.ExecQuery(Query)   
    Do While DBResultSet.NextRow           
        Dim s As String = DBResultSet.GetString("ma_Descrizione")
        Log(s)
    Loop

I get this value
14� TEST
Velocit�

Instead
14° TEST
Velocità

Is there a way to fix this?

Thank you for your valuable help.

 

[Erel]

I don't think that the charSet parameter does anything here.

1. How did you insert the data?
2. Does it look properly through Access itself?
3. Can you get it as bytes with GetBlob?