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: http://www.gmx.net/de/go/freephone
