help for export data
lazarus / 16-Databases

----------------------------------------------------------------------
magleft · 2013-12-03 14:19

Hi. In my program i use sqlite database.
when i try to export some data in text file or xls file, the data who
are in greek not exported or not recognize from notepad or excel.
I try to use AnsiToUtf8 but not work.
Can help me.
Thanks.

----------------------------------------------------------------------
kpeters58 · 2013-12-04 17:33

What is the encoding of your SQLite database?

----------------------------------------------------------------------
magleft · 2013-12-05 17:35

My database is encoding by UTF8.
For the txt file i found this solution:

function TFReport.convString(sx: string): string;
var
   ansi : string;
begin
   ansi := Utf8ToAnsi(sx);
   convString:=AnsiToUtf8(ansi);
end;

This function has the disadvantage of the refund by the original text.

----------------------------------------------------------------------
kpeters58 · 2013-12-06 17:34

That makes no sense to me.

Could you post a DB with one table containing one or more
'problematic' records?

----------------------------------------------------------------------
magleft · 2013-12-09 18:13

I use ZEXMLSS from http://avemey.com/zexmlss/index.php and fixed. I
suggest this comptonet for all programers who use non-engilsh
language.

kpeters58 Thanks a lot for your time and interst.