Re: Strange LOAD DATA problem

2002-01-06 Thread Paul DuBois
At 17:36 + 1/6/02, David Ayliffe wrote: >I have a file (data.txt) which contains the data: > >ELITEô85.ôQô4 DaysôLilleshallôChris >IMPô75.ôQôTues&FriôLilleshallôSue >LEFTô0.ôôôLeftô >PRESCô24.ôTôOne DayôWrekinôArleen >RECô27.ôQôTuesôWrekinôTony > >I use the "LOAD DATA" DDL

RE: Strange LOAD DATA problem

2002-01-06 Thread David Ayliffe
Yeah useful but that still doesn't solve my problem -Original Message- From: Maciek Dobrzanski [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 17:43 To: David Ayliffe; 'MySQL' Subject: Re: Strange LOAD DATA problem > Also I use the field delimiter ô (ALT+147) be

Strange LOAD DATA problem

2002-01-06 Thread David Ayliffe
I have a file (data.txt) which contains the data: ELITEô85.ôQô4 DaysôLilleshallôChris IMPô75.ôQôTues&FriôLilleshallôSue LEFTô0.ôôôLeftô PRESCô24.ôTôOne DayôWrekinôArleen RECô27.ôQôTuesôWrekinôTony I use the "LOAD DATA" DDL statement: LOAD DATA LOCAL INFILE "data.txt" INTO TA