Thread

1. field delimiter...

   Marc G. Fournier <scrappy@hub.org> — 1998-05-16T22:22:03Z

   
   Hello to everyone, I am using FreeBSD 3.0-current, Postgres-6.3.2 and
   heitml-1.2.3 for doing my degree at university on a research work...
   
   Now I have to use some fields in a table that can contain the ' which is
   very common in italian language ... 
   
   Is there a way of escape this one so I can put fields like :
   
   "Di che colore e' l'albero ?"
   
   
   Thanks for your attention, please reply directly to me too, because I am
   not on this list yet...
   
   
   -- 
   
   Regards...
   
   Gianmarco
   "Unix expert since yesterday"
   
   http://www.giovannelli.it
   
   
   

2. Re: [GENERAL] field delimiter...

   Anton Stckl <tony@cys.de> — 1998-05-18T08:07:20Z

   The Hermit Hacker wrote:
   > 
   > Hello to everyone, I am using FreeBSD 3.0-current, Postgres-6.3.2 and
   > heitml-1.2.3 for doing my degree at university on a research work...
   > 
   > Now I have to use some fields in a table that can contain the ' which is
   > very common in italian language ...
   > 
   > Is there a way of escape this one so I can put fields like :
   > 
   > "Di che colore e' l'albero ?"
   
   You'll have to use two single quotes like:
   
   insert into table values ('Di che colore e'' l''albero ?');
   
   -Tony
   -- 
   ----------C-Y-B-E-R-S-O-L-U-T-I-O-N-S----------------
   Anton Stöckl                    mailto:tony@cys.de
   CyberSolutions GmbH             http://www.cys.de
   Frankfurter Ring 193A           Phone +49 89 32369223
   80807 Muenchen                  Fax   +49 89 32369220
   ------W-E----M-A-K-E----I-T----P-O-S-S-I-B-L-E-------