Android Question sql utf8

C

catyinwong

Active Member
Licensed User
Longtime User
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?
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
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.
 
Upvote 0
C

catyinwong

Active Member
Licensed User
Longtime User

is there an example code for base64 encoding and decoding?
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
Use Encryption Library.

B4X: 
    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

B4X: 
' Read the base64 from db
    ' and decode it
    Dim decoded As String = b64.DecodeStoS(base64str,"UTF8")
    Log($"Base64 decoded = ${decoded}"$)
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question B4XPages scope of variables
Replies
6
Views
1K
Phayao
C
  • Question
Android Question Error: Given Key was not present... with git repository
Replies
3
Views
2K
Erel
  • Question
Android Question AppUpdating Lib (2.02) - URL problems [Solved]
Replies
6
Views
1K
stu14t
C
  • Question
Android Question How to change string to UTF8
Replies
4
Views
2K
catyinwong
C
  • Question
Android Question [SOLVED] SQLExample Help
Replies
2
Views
943
Uederson Ferreira
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…