Bug #1695
closed
usage of german characters in userlist filter results in jumbled characters
Description
When using german characters within a userlist filter it results in them jumbling to either a square or a question mark. This causes them to not match results properly when view the list on frontend.
Files
Updated by beat over 14 years ago
- Assignee set to krileon
- Target version set to CB 1.2.3
- Estimated time set to 1:00 h
Updated by krileon over 14 years ago
- File 1695.patch 1695.patch added
- Status changed from New to Assigned
- Assignee changed from krileon to beat
- % Done changed from 0 to 80
Issue wasn't database related. Values are stored properly, but not displayed properly.
Updated by beat over 14 years ago
- Status changed from Assigned to Closed
- % Done changed from 80 to 100
Fixed in commit r1061 , but differently, actually fixing function utf8RawUrlDecode() to output utf8 instead of the iso-8859-1 outputed by javascript escape() function.
Updated by nant over 14 years ago
- Status changed from Closed to New
reopened - tested using Greek chars in filter and filter doesn't work.
Updated by nant over 14 years ago
#
SELECT COUNT
FROM famus_comprofiler ue, famus_users u
WHERE u.block = 0
AND ue.approved = 1
AND ue.confirmed = 1
AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25)
AND u.`id` = ue.`id`
AND (`cb_famuscategory` LIKE '%Mουσικός%')
Updated by nant over 14 years ago
# SELECT COUNT(*) FROM famus_comprofiler ue, famus_users u WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND u.gid IN ( 18, 19, 20, 21, 30, 23, 24, 25) AND u.`id` = ue.`id` AND (`cb_famuscategory` LIKE '%Mουσικός%') # S
Updated by beat over 14 years ago
- Status changed from New to Closed
r1123 fixes the fix which wasn't working with multibyte utf8.
Updated by nant over 14 years ago
tested latest with Greek character test case and looks fixed!