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 6: explain analyze is your friend
