Project

General

Profile

Actions
Copy link

Bug #1695

closed

usage of german characters in userlist filter results in jumbled characters

Bug #1695: usage of german characters in userlist filter results in jumbled characters

Added by krileon over 15 years ago. Updated over 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
beat
Target version:
CB 1.2.3
Start date:
17 May 2010
Due date:
% Done:

100%

Estimated time:
1:00 h

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.

http://www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,view/catid,112/id,133159/#133159

Files

1695.patch (1.07 KB) 1695.patch krileon, 08 June 2010 15:37

Updated by beat over 15 years ago Actions
Copy link
 #1

  • Assignee set to krileon
  • Target version set to CB 1.2.3
  • Estimated time set to 1:00 h

Updated by krileon over 15 years ago Actions
Copy link
 #2

  • 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 15 years ago Actions
Copy link
 #3

  • 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 15 years ago Actions
Copy link
 #4

  • Status changed from Closed to New

reopened - tested using Greek chars in filter and filter doesn't work.

Updated by nant over 15 years ago Actions
Copy link
 #5

#
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 15 years ago Actions
Copy link
 #6

`cb_famuscategory` LIKE '%Mουσικός%'

Updated by nant over 15 years ago Actions
Copy link
 #7 

#
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 15 years ago Actions
Copy link
 #8

  • Status changed from New to Closed

r1123 fixes the fix which wasn't working with multibyte utf8.

Updated by nant over 15 years ago Actions
Copy link
 #9

tested latest with Greek character test case and looks fixed!

Actions
Copy link

Also available in: PDF Atom