Re: [sqlite] International Language Support

2005-08-06 Thread Dan Wellisch
I appreciate all who contributed their time and knowledge to this issue. The information that I failed to give to all of you is that we are issuing our SELECT statements such that all expressions in our WHERE clause are ids. The only exception is zipcode. I found the problem to be that since

Re: [sqlite] Import CSV in sqlite3?

2005-08-06 Thread Jens Miltner
Am 6.8.05 um 09:06 schrieb Joe Noon: You can use a system call to execute a command like the following; sqlite3 -separator , test.db ".import test.csv sometable" That is exactly what I needed! Thanks a ton. Joe Noon My issue now is that the csv may or may not have all of the columns t

Re: [sqlite] Import CSV in sqlite3?

2005-08-06 Thread Joe Noon
> > You can use a system call to execute a command like the following; > > > > sqlite3 -separator , test.db ".import test.csv sometable" > > > > That is exactly what I needed! Thanks a ton. > > Joe Noon > My issue now is that the csv may or may not have all of the columns that my table has. Fo