wbTeamPro Feature Request & Bug Tracker - wbTeamPro
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010295wbTeamPro[All Projects] Bugspublic2017-01-30 09:312015-01-25 00:00
Reportera104 
Assigned Towebuddha 
PrioritynormalSeveritytextReproducibilityalways
StatusResolvedResolutionfixed 
PlatformOSOS Version
Product Versionv3.0.17 
Target VersionApplied to Versionv3.1.0 beta 
Summary0010295: Wrong Encoding in timelogs.
DescriptionI'd like to report an issue with the text encoding when it gets trim on the Time Log page.

You may view the screenshot for more details.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0010245Resolved webuddha Task item encoding issue 
Attached Filesjpg sc.jpg (71,731) 2013-10-18 13:05
https://tracker.holodyn.com/file_download.php?file_id=20&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2013-10-18 13:05a104New Issue
2013-10-18 13:05a104
2013-10-18 13:05a104File Added: sc.jpg
2013-10-18 13:08a104Note Added: 0010066
2013-10-18 13:09a104Note Edited: 0010066bug_revision_view_page.php?bugnote_id=10066#r28
2013-12-17 11:43webuddhaRelationship addedrelated to 0010245
2013-12-17 11:50webuddhaNote Added: 0010071
2013-12-17 11:50webuddhaStatusNew => Resolved
2013-12-17 11:50webuddhaApplied to Version => v3.1.0 beta
2013-12-17 11:50webuddhaResolutionopen => fixed
2013-12-17 11:50webuddhaAssigned To => webuddha

Notes
(0010066)
a104   
2013-10-18 13:08   
(edited on: 2013-10-18 13:09)
Sorry for the double report, but I see that I had already reported this issue here: http://tracker.wbteampro.com/view.php?id=10245 [^]
(0010071)
webuddha   
2013-12-17 11:50   
We have found in nearly all cases that this has been the result of mixed encoding types within the database, where the older wbTeamPro and WHMCS used latin1 encoding, and the newer versions are using utf8 as the standard. In some cases where a CONCAT was being performed within the query, the value was being cast as the database default which in some cases differed from the table default. To correct this a CAST() operation has been added to all CONCAT() operations in the upcoming version.