B4J Question ucanaccess & Access 97 & special characters

Pesciolina

Active Member
Licensed User
Longtime User
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.

B4X:
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.
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…