Android Question sql utf8

[catyinwong]

I have already set the language of the sql server to be in utf8. When I update the data, the characters seem to be saved properly because I can select the correct rows using ExecQuery. But the jdbcresultset.getstring method doesn't read the right string and the strings become ???? when being read. Any suggestion to fix the problem?

 

[DonManfred]

Any suggestion to fix the problem?

Where is the project which shows the issue?

 

[catyinwong]

Where is the project which shows the issue?

 

[Erel]

You can add the charSet parameter to the connection string: charSet=UTF8

It does change the ResultSet charset (you can see it in the debugger) though the returned string is wrong. Maybe the database is not configured properly.

As a workaround you can store the text encoded with base64 string and decode it on the client.

 

[catyinwong]

You can add the charSet parameter to the connection string: charSet=UTF8

It does change the ResultSet charset (you can see it in the debugger) though the returned string is wrong. Maybe the database is not configured properly.

As a workaround you can store the text encoded with base64 string and decode it on the client.

is there an example code for base64 encoding and decoding?

 

[DonManfred]

The forumsearch is working https://www.b4x.com/android/forum/pages/results/?query=base64
- https://www.b4x.com/android/forum/threads/base64-encode-decode-image-library.31031/#content

 

[catyinwong]

The forumsearch is working https://www.b4x.com/android/forum/pages/results/?query=base64
- https://www.b4x.com/android/forum/threads/base64-encode-decode-image-library.31031/#content

sorry i am confused. do you mean it should decode it to bitmap?

and then how to encode it to string? I mean, how to turn the bitmap to filename and folder path?

 

[DonManfred]

Use Encryption Library.

    Dim teststring As String = "dhhjdfhshf jjkdjjk hsdjk fhsj kh fjksdf hs"
    Dim b64 As Base64
    Dim base64str As String = b64.EncodeStoS(teststring,"UTF8")
    Log($"Base64 (write it to DB) = ${base64str}"$)

and decode the string back

' Read the base64 from db
    ' and decode it
    Dim decoded As String = b64.DecodeStoS(base64str,"UTF8")
    Log($"Base64 decoded = ${decoded}"$)

 

[Erel]

StringUtils also supports base64 encoding and decoding.