Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

trouble with string

 
miguel lisboa
Ranch Hand
Posts: 1281
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Can someone please give me any hint?

TiA
 
Reid M. Pinchback
Ranch Hand
Posts: 775
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ernest Friedman-Hill
author and iconoclast
Marshal
Pie
Posts: 24211
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to "JDBC".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic