Android Question How to change string to UTF8

[catyinwong]

I want to update the information on a SQL server which complies with UTF8.

Reading data from the SQL is fine (there were old data with UTF8 characters) but when I try to save new data, the characters become unreadable.

I have tried stringutils.Encodeurl(txt, UTF-8) to encode the query before calling Sql.ExecQuery but it still send unreadable characters (turns to ???). Any other encoding functions that I can use?

 

[Erel]

How are you communicating with the SQL server?

 

[catyinwong]

How are you communicating with the SQL server?

using the jdbcsql

 

[Erel]

You don't need to encode or convert the strings. You might need to add the encoding to the jdbc url. Which driver are you using?

Might also be an issue in your server configuration.

 

[catyinwong]

You don't need to encode or convert the strings. You might need to add the encoding to the jdbc url. Which driver are you using?

Might also be an issue in your server configuration.

Problem solved. Searched for the SQL language and made changes on the SQL command. Thanks Erel.