+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Special character in field name ( pick list ) (/showthread.php?tid=1372)
Special character in field name ( pick list ) - rslemer - 01-21-2019
Now, name of picklist and itens in picklist, with a special characteres is not displayed correctly
In my config.inc.br set UTF-8
Only picklist and itens in pickist displayed wrong ..
How I can solved that?
But values for default system, is showed correctly, only my new values is showed wrong ...
RE: Special character in field name ( pick list ) - joebordes - 01-21-2019
I have no idea what is happening in your install
RE: Special character in field name ( pick list ) - rslemer - 01-21-2019
When I in listview cbTranslation shows correctly, but when clicked in edt shows wrong ..
See two images
If I change in editing mode manually, system shows correctly in picklist again ...
RE: Special character in field name ( pick list ) - rslemer - 01-24-2019
I correctly manualy almost, works fine now ..
Only a filter in payments, if I put any conditions in Custom Field ( pick list ) system not listem anything ...
Conditions in another type of filed, works normally
How I can solve that?
RE: Special character in field name ( pick list ) - joebordes - 01-26-2019
activate the debug list view query global variable and look at the query being launched. try not translating any values for that picklist: you only need to translate in a multilingual install or when the base values are not in the language of all the users.
RE: Special character in field name ( pick list ) - rslemer - 01-28-2019
SELECT vtiger_cobropago.cyp_no, vtiger_cobropago.parent_id, vtiger_crmentity.smownerid, vtiger_cobropago.paymentmode, vtiger_cobropagocf.cf_871, vtiger_cobropagocf.cf_977, vtiger_cobropago.amount, vtiger_cobropago.cobropagoid FROM vtiger_cobropago INNER JOIN vtiger_crmentity ON vtiger_cobropago.cobropagoid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = vtiger_users.id LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid INNER JOIN vtiger_cobropagocf ON vtiger_cobropago.cobropagoid = vtiger_cobropagocf.cobropagoid WHERE vtiger_crmentity.deleted=0 AND ( (( vtiger_cobropago.paid <> '1') )) AND vtiger_cobropago.cobropagoid > 0
Strange ... exactly a test for "Nota Promissória" is omitted in sql command ...
RE: Special character in field name ( pick list ) - joebordes - 01-28-2019
send a screen shot of the field and the filter
RE: Special character in field name ( pick list ) - rslemer - 01-28-2019
Attached
RE: Special character in field name ( pick list ) - joebordes - 01-28-2019
You are probably not seeing the correct SQL
Select the filter, go to another module and then come back to this one
RE: Special character in field name ( pick list ) - rslemer - 01-30-2019
I solved that, when I returned a item on picklist to old value "Audiencia" to "Audiência"
=)