2. PHPRunner General questions
  3. Accent character goes wrong in List page with search popup
This topic is locked

Accent character goes wrong in List page with search popup

 		9/10/2012 9:21:19 AM
PHPRunner General questions
R
 rencenji.denes author

Dear All!
In PHPRunner 5.3 I set up a fieleld with lookup wizzard. Lookup type: List page with search.
The source table contains accent hungarian words like: 'Árvíztűrőtükörfúrógép'.
When I use an accent letter for example 'Á' or 'Ő' or 'ö' there is no result.
But the 'Á' letter transformed to 'Á'. When I reopen the search panel the bad 'Á' is displayed in the search field.
And as I see the Database (oracle) got this sql.
SELECT ID, WORDS, DATE, WORDS||' '|| to_char(DATE,'YYYY-MM-DD') as "dispField1" FROM X.WORDS_TABLE where 1=0 or upper(WORDS) like upper('%Á%') or DATE like '%Á%' ORDER BY 1 ASC;
The search is woring well the list page and the problen does not occur just only the popup search.
Any suggestion? (Page charset change not work) I think this is a Javascript problem.

Where can I check the posted character or SQL?

Thanx!
BR:

Dennis
Sergey Kornilov admin 9/10/2012

I would suggest to check PHPRunner 6.1 where we have fixed similar issue. Let us know if this helps.
R
 		rencenji.denes author 9/11/2012



Dear All!
In PHPRunner 5.3 I set up a fieleld with lookup wizzard. Lookup type: List page with search.
The source table contains accent hungarian words like: 'Árvíztűrőtükörfúrógép'.
When I use an accent letter for example 'Á' or 'Ő' or 'ö' there is no result.
But the 'Á' letter transformed to 'Á'. When I reopen the search panel the bad 'Á' is displayed in the search field.
And as I see the Database (oracle) got this sql.
SELECT ID, WORDS, DATE, WORDS||' '|| to_char(DATE,'YYYY-MM-DD') as "dispField1" FROM X.WORDS_TABLE where 1=0 or upper(WORDS) like upper('%Á%') or DATE like '%Á%' ORDER BY 1 ASC;
The search is woring well the list page and the problen does not occur just only the popup search.
Any suggestion? (Page charset change not work) I think this is a Javascript problem.

Where can I check the posted character or SQL?

Thanx!
BR:

Dennis


Dear Sergey!
Unfortunately, there is no possibility to change version in Enterprise environment because of several application.
So if you could give me a starting point I would be very grateful. May be I can fix this problem.
BR:
Dennis