Saving information from EditText to DB

[Peter Simpson]

Hiya,
I've been developing an Android app to link to customers MySQL databases. All working except for the following.

I've noticed that when saving EditText (Single Line = False) text to MySQL database field varchar(200), the following happens for CRLF.

B4A appears to save return key press(CRLF - New line) as:
Hex 0A 00 = Chr(10) stored in DB

VB.Net appears to save return key press(CRLF - New line) as:
Hex 0D 00 0A 00 = Chr(13) & Chr(10) stored in DB

Is their anyway that I can get B4A to save return key press as Hex 0D 00 0A 00 = Chr(13) & Chr(10) instead of just Hex 0A 00 = Chr(10).

Reason:
My customers windows software shows all retrieved data saved from B4A EditText box on the same line, B4A EditText box shows data on separate lines when reading from MySQL DB.

I'm hoping that it is easier for me to save EditText information with 0D 00 0A 00 instead of just 0A 00 in DB, rather than spend hours going through vb.net and doing lots of Replace(Reader"..."), vbLf, vbCrLf) which does work...

Thanks you....
Please see screen shots.

 

[Peter Simpson]

Fixed it with the following line.

TxtInvAddress.Text = TxtInvAddress.Text.Replace(Chr(10), Chr(13) & Chr(10))