openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From No1UNo <>
Subject Re: problem with query / German umlaut
Date Mon, 05 Sep 2011 01:38:42 GMT
Can't provide much help, but I can testify to having done similar exercises with OpenJAP 2.0
and 2.1 using PostgreSQL without any problem.  I recommend logging your SQL statements and
verifying that the character encodings are passing through correctly.

On Aug 31, 2011, at 12:53 PM, Christopher Cudennec [via OpenJPA] wrote:

> Hi! 
> I have a simple (?) problem with a query against data with German umlaut characters.

> Consider the following data: 
> create table test (property varchar(255)); 
> insert into test values ('Diskontsatze'); 
> insert into test values ('Diskonts├Ątze'); 
> select * from test where prop = 'Diskontsatze'; 
> When querying the database using SQL I get one row as expected. When using the same query
with OpenJPA I unexpectedly get two rows. It looks like OpenJPA uses another collation than
my table and database. 
> As database I use MySQL. The default-character-set is "utf8". I tried to set the collation
for the table explicitly to 'utf8_unicode_ci' without any positive result. 
> What could be the problem? 
> Thanks, 
> Christopher 
> -- 
> NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zur├╝ck-Garantie!	
> Jetzt informieren:
> If you reply to this email, your message will be added to the discussion below:
> To start a new topic under OpenJPA Users, email

> To unsubscribe from OpenJPA Users, click here.

View this message in context:
Sent from the OpenJPA Users mailing list archive at
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message