About omitting ideographic space to create array.

From: shuhei_aoyama <aoyama(at)sysart(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: About omitting ideographic space to create array.
Date: 2013-06-04 05:48:28
Message-ID: 51AD7FAC.6010504@sysart.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

To respecting PIC

The version I used : postgresql-jdbc-9.1-901.jdbc4
When one of a Postgresql db table has array column which contains Strings.
And some of these Array slices contain ideographic space(U+3000 in
Unicode6.0).
In such a case returned result lacks this ideographic space.

My use case is this.
An array column has strings of names of image files.
And one of these name contains an ideographic space.
When a server program got data without this ideographic space and
created a hyperlink
using this data, our user found the link in a html page dose not work.
Because the real file's name contains that ideographic space and the
hyperlink dose not.

I think an abstract class named AbstractJdbc2Array in the package
org.postgresql.jdbc2
dose this mal-effect at line 451-455 as below,

// white space
else if (!insideString && Character.isWhitespace(chars[i]))
{
continue;
}

I know there are some other Whitespace characters like (CR, LF, HT
etc.), I tihink
at least ideographic space shoud not be ommited.

Sincerely Shuhei Aoyama from Tokyo.

Browse pgsql-bugs by date

  From Date Subject
Next Message Naoya Anzai 2013-06-04 07:45:01 Memory-leak in BackgroundWriter(and Checkpointer)
Previous Message mrenda 2013-06-04 04:40:54 BUG #8202: can't install database