Skip site navigation (1) Skip section navigation (2)

BUG #2693: Abut SQL ASCII through JDBC

From: "Delight Chen" <delight(at)nineder(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2693: Abut SQL ASCII through JDBC
Date: 2006-10-16 01:42:06
Message-ID: 200610160142.k9G1g6bw007196@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2693
Logged by:          Delight Chen
Email address:      delight(at)nineder(dot)com
PostgreSQL version: 8.1.4
Operating system:   Red Hat Enterprise Linux ES release 4 (Nahant) Kernel
2.6.9-5.ELsmp on an x86_64
Description:        Abut SQL ASCII through JDBC
Details: 

I tried to install postgresql 8.1.4
Initdb with SQL_ASCII is work.
Create table is correct.
Insert Big5 text data correctly.
Try to view through /usr/local/pgsql/bin/psql and it's correct.
But when I try to query throught JDBC Driver, it always says "invalid byte
value for encoding"


And I tried another version 7.3.3 of postgresql.
Do all of thing above I metioned, and check it.
Finally I check data throught JDBC Driver, it's work correctly.


I think it's a bug for 8.1.4, so I report to you.



Here is the log of Version 8.1.4
LOG:  duration: 1.700 ms  statement: set datestyle to 'ISO'; select
version(), c
ase when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseenc
oding() end;
LOG:  duration: 0.115 ms  statement: set client_encoding = 'BIG5'; show
autocomm
it
ERROR:  invalid byte value for encoding "SQL_ASCII": 0xa4


Here is the log of Version 7.3.3
LOG:  query: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_
char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end;
LOG:  query: set client_encoding = 'BIG5'; show autocommit
LOG:  query: select * from person_info where  memo=''

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-10-16 04:10:42
Subject: Re: BUG #2683: spi_exec_query in plperl returns column
Previous:From: David FetterDate: 2006-10-15 23:32:22
Subject: Re: BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group