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
encoding and provide the correct display of the various characters. -Original Message- From: hfiandor Sent: Friday, May 26, 2017 5:18 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] problem with special letters Dear collegues: i have an application with two ways

Re: [sqlite] problem with special letters

2017-05-26 Thread Stephen Chrzanowski
cas...@activenetwerx.com > wrote: > -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 w

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 d

[sqlite] problem with special letters

2017-05-26 Thread hfiandor
Dear collegues: i have an application with two ways to introduce data in the associate table: by keyboard o thru a bottom named "Insert". My language is Spanish, and some letters can have a special sign: a and á, for example. If i introduce a word as Biología by the keyboard, no problem.