PostgreSQL runs on machines that use EBCDIC? On Mon, Oct 10, 2005 at 04:26:15PM +0100, [EMAIL PROTECTED] wrote: > Here is a direct quote from the ORACLE manual: > > <quote> > 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. > </quote> > > Tony Marston > http://www.tonymarston.net > > pgman@candle.pha.pa.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 | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
-- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
