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

Bug #705: Invalid UNICODE character sequence found (0xc236)

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #705: Invalid UNICODE character sequence found (0xc236)
Date: 2002-07-09 18:58:38
Message-ID: 20020709185838.B36A1475939@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Peter Czulak (pczulak(at)cybercom(dot)net) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Invalid UNICODE character sequence found (0xc236)

Long Description
PostgreSQL version 7.2.1
OS: RedHat Linux 7.2
Platform: IBM 220 server
Some insert statements are failing when inserted into the UNICODE encoded database. The same insert statement works on SQL_ASCII and Latin9 encoded database.
When a file name was changed for the ftp_file column (see the code example) from 300319TLOG07042002.zip to X300319TLOG07042002.zip then the
insert statement worked in the UNICODE encoded database.
Some of the insert messages with identical structure but different names also starting with integer worked.

Data base was build on the server with enable multibyte option
also init db was initialized with -E UNICODE
and database was created with -E UNICODE.

Thank you
Peter Czulak

Sample Code
INSERT INTO ftp_log_t (ftp_log_source, ftp_from_site_id, ftp_file_status, ftp_file, ftp_log_date, ftp_file_date, ftp_file_size, ftp_insert_date) VALUES ('DD',300319,'ST','c:\Inetpub\FTPRoot\300319\300319TLOG07042002.zip','07-04-2002 14:30:36','2002-07-04 14:00',43514,'2002-07-05 08:22:43')

	CREATE TABLE ftp_log_t
	(ftp_id integer DEFAULT nextval('ftp_log_seq') NOT NULL,
	ftp_log_source varchar(64) NOT NULL,
 	ftp_from_site_id integer NOT NULL,
	ftp_file_status varchar(32) NOT NULL,
 	ftp_file varchar(256) NOT NULL,
 	ftp_file_size integer,
 	ftp_log_date timestamp NOT NULL,
 	ftp_file_date timestamp,
 	ftp_insert_date timestamp NOT NULL,
 	PRIMARY KEY (ftp_id));



No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-07-09 23:46:46
Subject: Bug #706: Wrong shlib flag for GCC compilation on Solaris
Previous:From: Bruce MomjianDate: 2002-07-09 15:40:49
Subject: Re: Insert aborted, but Sequence increased

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