A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars?
От | Jani Averbach |
---|---|
Тема | A bug with pgsql 7.1/jdbc and non-ascii (8-bit) chars? |
Дата | |
Msg-id | Pine.GSO.4.21.0105032126380.22428-100000@tukki обсуждение исходный текст |
Ответ на | A bug fix for JDBC's getTables() in Postgresql 7.1 (Panu Outinen <panu@vertex.fi>) |
Список | pgsql-jdbc |
Hi! I have a problem like that: Environment: The database is postgresql v7.1, with locale-support jdk is sun's jdk1.3.0_02 and jdbc is that one which comes with postgres (type 2). Both database and jdbc driver has been build by myself. OS: RH 6.2 based linux with 2.4.3 kernel, glibc 2.1.3. The problem: There is a database which contains fields (the field's type is 'text') with scandinavian alphabet. (Especially ÖÄÅöäå (odiaeresis, adiaeresis, aring, or in other words, oe, ae, and a with ring above it)). The database has been installed, created and used under LC_ALL="finnish" and LANG="fi_FI" environment variables in act. Ok, the problem: When I try to read those field, I get guestion marks instead of those 8-bit scandic chars. I have been check my java programs and the database. (in fact, same problem appears with postgres-7.1/src/interfaces/jdbc/example/psql.java). In general, my java environment works fine with 8-bit chars, with psgl (not the java one) there is everything very well with those fields with 8-bit chars. So my question is, am I doing something wrong, or is there a bug in the pgsql-jdbc? If this is a bug or you need otherwise help or more information, please let me know. I will try to help as much as possible to hunt this one down. If I am doing something stupid, I would very likely to know it... BR, Jani --- Jani Averbach
В списке pgsql-jdbc по дате отправления: