i'm developing a home app (swing standalone app and database) in my laptop (for a long time...) my environment: winXP home SP2 eclipse 3.1 with all updates using visual editor for eclipse hibernate 2.1.7 MySQL 4.1.10a-nt java version "1.5.0_06" Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05 Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode, sharing)
my app is nearly finished, so i made a jar (troubles with this will follow) and tried it in my pc, wich is winXP pro SP2, and then installed the same MySQL; the jre is the very same
at a certain point my app has a button that populates some fields based in a hql query:
private final String QUERY_CONTRATO_T =
"from ContratoTecnica c "
+ "WHERE nomeActoMedico = ? "
+ "and tipoContrato = ? "
+ "order by nomeActoMedico asc, data desc";
both nomeActoMedico and tipoContrato are strings. What happens is extraordinary: in my laptop everything goes fine, but in my pc the query doesnt return as expected, when strings include some characters, like: "Conven��o", "Domic�lio" and so on
I dont have the smallest idea why this is happening
Sounds like a character set issue. If this were Oracle I'd say you needed to use NVARCHAR and configure the database to allow 16-bit characters. Not sure how MySql deals with such issues, don't use it that often.