Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004998opensim[GRID] User Servicepublic2010-08-30 02:522010-09-06 02:44
ReporterFoTo50 
Assigned To 
PrioritynormalSeveritytweakReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0004998: MySQL collations
DescriptionThis might not be a big issue at the moment, but I thought I post it here before it could become one:

After a fresh installation of 0.7.0.1 with MySQL as storage, I found the collation of the field 'PrincipalID' in the table 'UserAccounts' beeing utf8_general_ci, while the equal field 'UserID' from the table 'GridUser' is set to utf8_unicode_ci. This might look as a trivial difference for most, but in my MySQL version (5.1.36) a JOIN query comparing those 2 fields will cause an error:
[Err] 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

I did not yet check other references, but I think it would be a good idea to stay with the same collation for all char fields.

greets Georg
Tagsmysql
Git Revision or version number0.7.0.1
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBasicPhysics
Script Engine
EnvironmentMono / Linux64
Mono Version2.4.2
Viewer
Attached Files

- Relationships

-  Notes
(0016748)
randomhuman (reporter)
2010-09-05 08:33

I agree that this is a nuisance, but you can do the join by explicitly changing the collation of one of the columns:

SELECT *
FROM `UserAccounts`
JOIN `GridUser`
ON `UserAccounts`.PrincipalID COLLATE utf8_unicode_ci = `GridUser`.UserID
(0016761)
FoTo50 (reporter)
2010-09-06 02:44

That's true and thanks for this hint. This is why I considered the severity not even as an error but just as a tweak.

- Issue History
Date Modified Username Field Change
2010-08-30 02:52 FoTo50 New Issue
2010-08-30 02:52 FoTo50 Git Revision => 0.7.0.1
2010-08-30 02:52 FoTo50 SVN Revision => 0
2010-08-30 02:52 FoTo50 Run Mode => Grid (Multiple Regions per Sim)
2010-08-30 02:52 FoTo50 Physics Engine => BasicPhysics
2010-08-30 02:52 FoTo50 Environment => Mono / Linux64
2010-08-30 02:52 FoTo50 Mono Version => 2.4.2
2010-09-03 05:08 FoTo50 Tag Attached: mysql
2010-09-05 08:33 randomhuman Note Added: 0016748
2010-09-06 02:44 FoTo50 Note Added: 0016761


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker