[JDBC] ? (question mark) characters
Ok, I tried all the drivers currently available at http://jdbc.fastcrypt.com. They all seem to correct the problem with long (8k) SQL statements, but they're all broken considering Portuguese characters like áéíóú (aeiou with accent)... they are replaced by question marks (?)... any ideas? Should I try to compile my own drivers? How? BTW I am using JDK 1.3 from Sun (Solaris and Linux)... -- Ricardo Pardini [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [JDBC] ? (question mark) characters
Thank you all for your help: Dia Thursday, 30 de August, 2001 10:42, Rene Pijlman wrote: like áéíóú (aeiou with accent)... they are replaced by question marks (?)... any ideas? What's the character encoding of the database? It doesn't matter. I have tried it with SQL_ASCII, ISO-8859-1, and with an installation on Solaris which doesn't have encodings (psql -l doesnt list the Encoding field). Strange thing is, if I use the jdbc7.0-1.2.jar from http://jdbc.postgresql.org, the special characters work ok. But then I have the 8k statement limitation problem. Are these special characters converted when you store them in the database, or when you retrieve them from he database? They're converted when I insert. I can insert the same characters directly into psql (into the same table) and it works ok (I can retrieve them without problems). I can use LIBPQ apps (PHP, PGACCESS etc) and it works ok with all backends (running with encodings SQL_ASCII, ISO, etc)... -- Ricardo Pardini [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[JDBC] JDBC version
I've been experimenting with some versions of PostgreSQL JDBC trying to find a version that suits the our application: 1) It has to support portuguese characters (like áéíóú etc) directly in SQL queries. 2) It is desiderable that it supports SQL statements longer than 8k. Unfortunately the only version I found that seems to address both problems above (version 7.1-1.2 from jdbc.postgresql.org) seems to be broken in relation to data types (not gone deeper into that, yet). Anyway what I would like to ask is if there is a way to use Large Object code to overcome statement length restrictions in the 7.0 series drivers (which work ok except for that). A detail is that I use FUNCTIONs for performing INSERT/UPDATE (as if the FUNCTION was a stored procedure, that does UPDATE or INSERT when appropriate): SELECT registerData('my_primary_key', 'a very very long text string') Is there a way I can do that using PreparedStatement ps = conn.prepareStatement(SELECT registerData(?,?)); ps.SetString(1, my_primary_key); ps.SetString(2, a very very very very long string); That way I could use a more stable driver with long datasets. Is it possible? Are the LOB functions stable? Thanks a lot! -- Ricardo Pardini [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly