From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org, lockhart(at)fourpalms(dot)org |
Subject: | Re: unknownin/out patch (was [HACKERS] PQescapeBytea is |
Date: | 2002-04-08 23:46:35 |
Message-ID: | 3CB22BDB.7030000@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Tatsuo Ishii wrote:
>
>
> Try a multibyte encoding database. For example,
>
> $ createdb -E EUC_JP test
> $ psql -c 'SELECT SUBSTRING('1234567890' FROM 3)' test
> substring
> -----------
> 3456
> (1 row)
>
> Apparently this is wrong.
> --
> Tatsuo Ishii
This problem exists in CVS tip *without* the unknownin/out patch:
# psql -U postgres testjp
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
testjp=# SELECT SUBSTRING('1234567890' FROM 3);
substring
-----------
3456
(1 row)
testjp=# select * from pg_type where typname = 'unknown';
typname | typnamespace | typowner | typlen | typprtlen | typbyval |
typtype | typisdefined | typdelim | typrelid | typelem | typinput |
typoutput | typreceive | typsend | typalign | typstorage | typnotnull |
typbasetype | typtypmod | typndims | typdefaultbin | typdefault
---------+--------------+----------+--------+-----------+----------+---------+--------------+----------+----------+---------+----------+-----------+------------+---------+----------+------------+------------+-------------+-----------+----------+---------------+------------
unknown | 11 | 1 | -1 | -1 | f | b
| t | , | 0 | 0 | textin |
textout | textin | textout | i | p | f |
0 | -1 | 0 | |
(1 row)
This is built from source with:
#define CATALOG_VERSION_NO 200204031
./configure --enable-locale --enable-debug --enable-cassert
--enable-multibyte --enable-syslog --enable-nls --enable-depend
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-04-09 00:35:48 | Re: timeout implementation issues |
Previous Message | Hiroshi Inoue | 2002-04-08 23:38:31 | Re: timeout implementation issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2002-04-09 01:23:42 | Re: unknownin/out patch (was [HACKERS] PQescapeBytea is |
Previous Message | Michael Meskes | 2002-04-08 06:42:54 | Re: ECPG patch for recent ALTER TABLE / S|D NOT NULL changes |