[Lazarus] FreePascal/Lazarus Components to access Sqlite databases --> Tutorial 01 - A basic address book

[Mattias Gaertner]

On Fri, 12 Sep 2008 22:18:41 -0300
Luiz Americo Pereira Camara <luizmed at oi.com.br> wrote:

> Usuario Anónimo wrote:
> > Hello, I download the file dataset_tutorial_01.zip from
> > http://www.geocities.com/camara_luiz/docs/dataset/dataset-tutorial-01.html.
> >
> > When I try compile the project I get the next error:
> >
> > Project raised exception class 'EDatabaseError'.
> >
> > Why?
> >   
> 
> Sqlite3 expects UTF8 encoded file names. Probably your config dir
> path contains accented characters and GetAppConfigDir returns ansi
> encoded instead of UTF8.
> 
> Replace
> 
> FileName := IncludeTrailingPathDelimiter(GetAppConfigDir(False)) + 
> 'data.db';
> 
> by
> 
> FileName := 
> UTF8Encode(IncludeTrailingPathDelimiter(GetAppConfigDir(False)) + 
> 'data.db');

or

FileName := IncludeTrailingPathDelimiter(GetAppConfigDirUTF8(False)) + 'data.db';

(unit FileUtil)

Mattias