For instance, Supplier.findByName('Röde Orm') returns null even though this name exists in the field "SearchName" in table "Supplier". Is this correct or do I have to do some reconfiguration of grails?
Well, now the problem disappeared. I don't know why I got the problem in the beginning but I know that the URLEncoder.encode was completely wrong to use here but I never thought about that and after doing some corrections in the database, still using varchar, things started to work but not until I removed the URLEncoder call.