[BUGS] Bug #653: Unable to insert binary data into BYTEA column in UTF8 DB

Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to insert binary data into BYTEA column in UTF8 DB Long Description After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA columns

[BUGS] Bug #654: lower and to_ascii don't work with UTF8

Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description lower and to_ascii don't work with UTF8 Long Description String functions (to_ascii and lower tested) don't work with UTF8. Sample Code No file was uploaded with th

Re: [BUGS] Bug #653: Unable to insert binary data into BYTEA

> After creating an UTF8 database ("createdb --encoding "UTF8" ...) containing BYTEA >columns the parser rejects insert queries with binary data because they're not UTF8 >encoded (escaping doesn't help ;-). I don't kno how exactly escaped them, but you need to escape bytes > 0x7f (PQescapebytea

Re: [BUGS] Bug #654: lower and to_ascii don't work with UTF8

> Peter Vicen ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > lower and to_ascii don't work with UTF8 > > Long Description > String functions (to_ascii and lower tested) don't work with UTF8. Regarding to_ascii: "The

[BUGS] createdb comments

Head of development branch (7.3devel) has a problem applying a comment to a database at the sametime as the database is created using the createdb utility. The error message states the problem: pgsql-current-test$ createdb testdb Test CREATE DATABASE ERROR: Database comments may

Re: [BUGS] Bug #651: Time difference of 30 in while reading in timestamp

Actually the Timestamp class does not use Timezone. Timezone in Java 1.3 can be set only on Calendar class objects. Timestamp inherits some methods from the Date class but none which concerned with setting timezones :-( Ravi Tom Lane <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] writes: > > I am

Re: [BUGS] LIKE Command

... > This previously worked but now it will only work if I put some sort of > expression in the string (ie a % at the end)... I am guessing that you have some blanks or other characters at the end of the string. Simple test cases here do not show a problem. - Thomas --

[BUGS] Bug #655: win32 client and bytea column

Krzysztof Stachlewski ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description win32 client and bytea column Long Description I have a problem with using bytea column with PHP. I am using Apache 1.3.24 on Windows 2000, PHP 4.2.0 install

[BUGS] Bug #656: timestamp function generates parsing errors when used as specified in the documentation

Bron Gondwana ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description timestamp function generates parsing errors when used as specified in the documentation Long Description See the following session examples using the form given in t

Re: [BUGS] Bug #656: timestamp function generates parsing errors when used as specified in the documentation

[EMAIL PROTECTED] writes: > See the following session examples using the form given in the documentation. >'select timestamp(now());' fails similarly. I'm afraid you've got bit by our continuing pursuit of SQL standard compliance. The 7.2 release notes do point out: Observe the following inco