Problems with special chars running tests.

Classic Servoy
1

Hello,

I am having a problem when running test with Servoy 5.2.6 and using special chars like Geman Umlauts (ä,ö,ü,…)

So I for an example I want to test the following simple function:

function onAction(event) {
	forms.frmPlanung.pl_status="Bestätigt";
}

This works perfect in WebClient, SmartClient, not dependent if running in Developer or Server.

But if I am using this function inside a test (even same solution, same DB):

function testAbc()
{
forms.frmPlanung.onAction();	
}

I always get an error like:

com.servoy.j2db.dataprocessing.DataException: Incorrect string value: '\xE4tigt' for column 'PL_STATUS' at row 1

Is this a bug ? Any workaround know ? Of course I know it is related to char encodings and UTF8 and so on - but where can I change there anything for running tests ?

Thanks for your help.

Schoby

2

Schoby,

I tried your example on my mysqldb and it worked as expected for me.

You could try setting the character encoding explicitely in the jdbc url.

jdbc:mysql://host:port/yourdb?characterEncoding=utf-8

Rob

3

Hi Rob,

thanks for the advice with the JDBC option ?characterEncoding=utf-8. This did the trick ! Now everything works as expected.
Thanks a lot for your help !

Steffen