How to do SQL Query with special characters?

[shobits1]

I have an MS-Access database (a .mdb file) that I want to do some work on.
the problem I'm facing is that the tables names have some special characters like: é è ° (french naming) and the fields names in some table have the same issue. the TSQLQuery always raises an error when ever I do a SELECT with specific fields. I tried to use [] and `` but nothing works..

Code: MySQL  [Select][+][-]

1. # does not work
2. SELECT N°Ins
3.       ,Réf_Group
4.       ,Réf_Section
5. FROM `Etudiants`
6.  
7. # does not work
8. SELECT `N°Ins`
9.       ,`Réf_Group`
10.       ,`Réf_Section`
11. FROM Etudiants
12.  
13. # does not work
14. SELECT [N°Ins]
15.       ,[Réf_Group]
16.       ,[Réf_Section]
17. FROM Etudiants
18.  
19. # works but displays fields names with ?
20. SELECT *
21. FROM Etudiants
22.  

Please help me.

BTW... is it possible to use Zeos to connect to MS-Access database? how?

Also I'm using the last official release of lazarus (v1.6.2)

[shobits1]

Anyone? 

[Thaddy]

Is the msaccess database in UTF8 format or in the French codepage?
As long as the database encoding is UTF8 it should work. If it is in the French MS codepage you will need to do some extra work.

[shobits1]

it's not UTF8.. (it's an old .mdb file)
what extra work, I need to do?

BTW.. I tried the same file with delphi (XE6) and it works just fine. still I'd like to do this on lazarus (I need the FPSpreadSheet component).

Thaddy,,, any guide/hint/help will be appreciated.

[shobits1]

Should I report this as bug or what??   

[Cyrax]

Grab fpcupdeluxe and install development versions (the trunks) of FPC and Lazarus. Then do a test and if there is bug, then report.

[paweld]

If database isn't utf8 format, then try like this:

Code: Pascal  [Select][+][-]

1. Query1.SQL.Clear;
2. Query1.SQL.Add(' SELECT [N°Ins], [Réf_Group], [Réf_Section] ');
3. Query1.SQL.Add(' FROM Etudiants ');
4. //convert query to database codepage
5. Query1.SQL.Text:=UTF8ToCP1252(Query1.SQL.Text);
6. Query1.Open;

Add LConvEncoding to uses section.

[shobits1]

Cyrax, the problem persist on at least the trunk from December's 25... this maybe due to FPC using UTF8 by default internally; I don't really know but I think this is the case since paweld's code works fine.

Thanks,, Paweld... converting the SQL query from UTF8 to ANSI did the trick.

Now, I can switch back from Delphi and continue my work. 

[Cyrax]

Then you probaly need to add ${codepage utf8} somewhere after {$mode objfpc}{$H+} stanza.

[shobits1]

Then you probaly need to add {$codepage utf8} somewhere after {$mode objfpc}{$H+} stanza.

does not work.