Thread: How to change Encoding coming from MySQL Webserver

Phil M wrote: If its undefined and you KNOW its UTF8 Encoding was Undefined and I used: FirstNameField.Text = DefineEncoding( rs.Field(" firstname ").StringValue, Encodings.UTF8 ) Thanks much Phil works great. I had tried nearly every conversion but the DefineEncoding, because with the gibberish I was getting back, I assumed it could not be utf8 the server was sending. Things are not always what they appear to be! -Dudley...

To see what encoding is being used use: Code: Dim s As String s = rs.Field( "firstname" ).StringValue If Not ( s.Encoding Is Nil ) Then   MsgBox( s.Encoding.InternetName ) Else   MsgBox( "Encoding is undefined for: " + s ) End If If its undefined and you KNOW its UTF8 Code: rs = app.hhtDB.SQLSelect( "Select * from people where id = 11" ) FirstNameField.Text =...

when it comes to exchange data with some other system, it is best to define/convert encodings in this way: - your app retrieves data: DefineEncoding (i.e. Reading a RecordSet: Define the Encoding of the retrieved data) - you send data: ConvertEncoding (i.e. you Update a RecordSet, or you execute some SQL) with these two "rules", we don't have any problems with different DB-Servers.