Home » U++ Library support » U++ SQL » SQLArray + Like() + Accents problem
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
|
|
|
Goto Forum:
Current Time: Tue May 21 20:02:46 CEST 2024
Total time taken to generate the page: 0.02624 seconds
|