Re: [sqlite] problem with special letters

2017-05-27 Thread Simon Slavin
On 27 May 2017, at 12:41pm, hfiandor wrote: > Following your suggestions (you send to me some time ago) i have written the > needed routines in the program. > i am sure there is a more efficient way to obtain this results. > i have read the command line file section 8,

Re: [sqlite] problem with special letters

2017-05-27 Thread hfiandor
Dear Simon: i am using window10 and Lazarus v1.6 FPC 3.0.0 Really, i dont know the Lazarus Tool for reading my .csv file. Following your suggestions (you send to me some time ago) i have written the needed routines in the program. i am sure there is a more efficient way to obtain this results. i

Re: [sqlite] problem with special letters

2017-05-26 Thread jose isaias cabrera
Make sure your CSV file is save as UTF-8 with encoding. If it is, then the import piece of Lazarus does not pick up UTF8 characters correctly. If any text file has an encoding or Byte Order Mark (BOM) at the beginning of the file, a good program should be able to interpret the correct

Re: [sqlite] problem with special letters

2017-05-26 Thread Stephen Chrzanowski
Joseph; FYI, Lazarus is a programming IDE for the Pascal language. It comes built with Free Pascal. Laz comes with built in SQLite3 support, but I've never played with that part of its functionality as I use other wrappers from Delphi. On Fri, May 26, 2017 at 5:33 PM, Joseph L. Casale

Re: [sqlite] problem with special letters

2017-05-26 Thread hfiandor
Dear Mr. Simon: Thanks for your rapid answer. I just am using your suggestion of insert into and it work fine. I will try to read the files you suggest. (and study) Thanks again hfiandor ___ sqlite-users mailing list

Re: [sqlite] problem with special letters

2017-05-26 Thread Simon Slavin
On 26 May 2017, at 10:18pm, hfiandor wrote: > I think: Lazarus work well when the data is introduced by keyboard, but > something fail when read a .csv (Biología) and translate to the SQLite´table > "Biolog¿a" with the insert into... command. Dear Hector, Which

Re: [sqlite] problem with special letters

2017-05-26 Thread Joseph L. Casale
-Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of hfiandor Sent: Friday, May 26, 2017 3:18 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] problem with special letters > I think: Lazarus work well when the data is