add item containing accute accent to TComboBox (FMX)

  

I am running a query that populates a TComboBox to let users filter results displayed in a ListView. One of the query results has an E with an accute accent character. The word is CIGRÉ. It shows up in my ComboBox as CIGR…, as shown below.

I have been scrubbing the data to replace the É with an E. Is there a way to modify the query so it retains the original É?

Below is my query code, it returns unique committee names from a big list of meetings (mtgs).

Form1->FDConnection1->Params->Values[“ColumnMetadataSupported”] = “False”;
Form1->FDConnection1->Params->Values[“Database”] = System::Ioutils::TPath::Combine(System::Ioutils::TPath::GetDocumentsPath(), “local.db”); // i’m using ifdefs to set this properly for platform (not shown)

query->SQL->Text = “SELECT DISTINCT committee FROM mtgs ORDER BY committee”;
query->Open();
while (!query->Eof) {
Form1->cmbBoxFilters->Items->Add(“Show ” + query->FieldByName(“committee”)->AsString);
query->Next();
}

p.s. I’m building in C++Builder 10.2 Version 25.0.29899.2631 and the app is for Win32, iOS, and Android. I’m using FireDAC to access the db. The committee field is type TEXT. The TFDConnection setting for Driver is SQLite. The db file is SQLite version 3 (SQLite3).

UPDATE 1: I have been using SQLiteManager to import CSV data into my db. I’ve set it to UTF-8, UTF-16, and UTF-32 and all give the same result. The CIGRÉ gets converted to CIGR… by SQLiteManager. This is clearly not a problem with my code. I apologize for wasting folks time.

Comments are closed.