Thomas Dudziak dijo: > Well I'm no expert when it comes to PostgresSQL, but there seems to be > some problem between PostgresSQL and Java when using unicode. See here: > > http://linux.kieser.net/java_pg_unicode.html
Thanks for the link. > > Also, PostgresSQL must be compiled with --enable-multibyte. Of course it is. > > Have you tried to specify the charSet in the jdbc url like this : > > jdbc:postgresql://[host]/[dbname]?charSet=UNICODE Yes, I already added this in my repository.xml and don't help. Please note I can use ����� without problem my problem is with the normal "z" in lower or upper case. AFAIK, this is not a problem in the postgres. > BTW this problem does not seem to exist with older (6.5) jdbc drivers. Not sure. My postgreSQL database is 7.3.4 and was installed from a rpm. Note we are able to create the database without any problem. We can also insert fields with "z" and search any string without "z". This is why I guess the problem is in OJB and not in the driver. > You could also use P6Spy to see what the offending SQL was. Hmm. I don't know how to use it. :-( Best Regards, Antonio Gallardo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
