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

Re: BUG #1947: Enhancement Request - CONCAT() function

From: tony(at)marston-home(dot)demon(dot)co(dot)uk
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "'David Fetter'" <david(at)fetter(dot)org>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function
Date: 2005-10-10 15:26:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Here is a direct quote from the ORACLE manual:

On most platforms, the concatenation operator is two solid vertical bars, as shown in Table 3-3. However, some IBM platforms use broken vertical bars for this operator. When moving SQL script files between systems having different character sets, such as between ASCII and EBCDIC, vertical bars might not be translated into the vertical bar required by the target Oracle environment. Oracle provides the CONCAT character function as an alternative to the vertical bar operator for cases when it is difficult or impossible to control translation performed by operating system or network utilities. Use this function in applications that will be moved between environments with differing character sets.

Tony Marston

pgman(at)candle(dot)pha(dot)pa(dot)us wrote:
> Tony Marston wrote:
> > > which Oracle supports and MySQL can be made to support via a 
> > > runtime option.
> > 
> > They also both support CONCAT() because there are sometimes difficulties in
> > dealing with vertical bars in the character sets used by certain operating
> > systems and file systems. If enough database vendors offer it then it becmes
> > a "de facto" standard.
> I have never heard of problems with vertical bars in any of those
> settings.  Can you elaborate?  I don't see how operating systems and
> file system character sets relate to SQL query characters.
> -- 
>   Bruce Momjian                        |
>   pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to


pgsql-bugs by date

Next:From: Jim C. NasbyDate: 2005-10-10 17:19:25
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function
Previous:From: Kevin GrittnerDate: 2005-10-10 14:50:22
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function

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