U++ forum: Welcome to the forum

SQLArray + Like() + Accents problem [message #30791]

Sun, 23 January 2011 00:38

alex100
Messages: 118
Registered: November 2007

Experienced Member

Hi all

Suppose the clients table (SQLite) has the following contents on field (column) name:

J�lio Ferraz
J�lia Sotinova
Jusefina Braz
Jumila Carter

Now, I want to select names by using the first two chars.
I used a SQLArray (named dbgrid) and I am using the query() method to issue the Where clause.
I am formating the where clause like this:

(Supose strIniciais String variable has the contents of an editbox used to read the two characters)

SqlBool where1;
where1 = Like(Name,Format("%s%s%%",strIniciais.Mid(0,1),strIniciais.Mid(1,1)));
dbgrid.SetOrderBy(Name);
dbgrid.Query(where1);

If I write Ju in editbox the SQLArray shows
Jusefina Braz
Jumila Carter

which is correct.

If I write J� (u with an accent) in editbox the SQLArray shows nothing.
Why?

I used a client GUI for SQLite, I opened the database and issued the following SQL statment:
Select * from clients where Name like 'J�%';

(u with an accent)

and it worked. So it seems that the problem is on UPP c++ code.

Any help?

Thanks a lot

Alex

Report message to a moderator