Grouper Users - Open Discussion List

["Waldbieser, Carl" <>]

Scott,

How do the non-ASCII characters render?  Are they question marks or odd bytes 
in the HTML source?
What coallation is you source database using?  utf8_unicode_ci?  
utf8_general_ci?

Thanks,
Carl Waldbieser
ITS System Programmer
Lafayette College

----- Original Message -----
From: "Scott Koranda" 
<>
To: "grouper-users" 
<>
Sent: Monday, March 2, 2015 9:34:28 PM
Subject: [grouper-users] JDBC subject source in sources.xml and unicode 
characters not displaying in UI

Hi,

I am using Grouper 2.2.1.

I have defined in sources.xml the source

  <source 
adapterClass="edu.internet2.middleware.grouper.subj.GrouperJdbcSourceAdapter2">
    <id>some_id</id>
    <name>Some name</name>
     <type>person</type>
     <init-param>
       <param-name>jdbcConnectionProvider</param-name>
       
<param-value>edu.internet2.middleware.subject.provider.C3p0JdbcConnectionProvider</param-value>
     </init-param>
     <init-param>
       <param-name>maxActive</param-name>
       <param-value>16</param-value>
     </init-param>
     <init-param>
       <param-name>maxIdle</param-name>
       <param-value>16</param-value>
     </init-param>
     <init-param>
       <param-name>maxWait</param-name>
       <param-value>-1</param-value>
     </init-param>
     <init-param>
       <param-name>dbDriver</param-name>
       <param-value>com.mysql.jdbc.Driver</param-value>
     </init-param>
     <init-param>
       <param-name>dbUrl</param-name>
       
<param-value>jdbc:mysql://localhost/registry?useUnicode=true&amp;characterEncoding=UTF-8</param-value>
     </init-param>
     <init-param>
       <param-name>dbUser</param-name>
       <param-value>grouper</param-value>
     </init-param>
     <init-param>
       <param-name>dbPwd</param-name>
       <param-value>XXXXXXXX</param-value>
     </init-param>
     <init-param>
       <param-name>maxResults</param-name>
       <param-value>1000</param-value>
     </init-param>
      <init-param>
       <param-name>dbTableOrView</param-name>
       <param-value>cm_co_grouper_subjects_3</param-value>
     </init-param>
      <init-param>
       <param-name>subjectIdCol</param-name>
       <param-value>id</param-value>
     </init-param>
     <init-param>
       <param-name>nameCol</param-name>
       <param-value>name</param-value>
     </init-param>
     <init-param>
       <param-name>descriptionCol</param-name>
       <param-value>description</param-value>
     </init-param>
     <init-param>
       <param-name>lowerSearchCol</param-name>
       <param-value>description_lower</param-value>
     </init-param>
     <init-param>
       <param-name>defaultSortCol</param-name>
       <param-value>description</param-value>
     </init-param>
     <init-param>
       <param-name>sortAttribute0</param-name>
       <param-value>description</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeCol0</param-name>
       <param-value>email</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeName0</param-name>
       <param-value>email</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeCol1</param-name>
       <param-value>loginid</param-value>
     </init-param>
     <init-param>
       <param-name>subjectAttributeName1</param-name>
       <param-value>loginid</param-value>
     </init-param>
     <init-param>
       <param-name>searchAttribute0</param-name>
       <param-value>searchAttribute0</param-value>
     </init-param>
     <internal-attribute>searchAttribute0</internal-attribute>
     <init-param>
       <param-name>subjectIdentifierCol0</param-name>
       <param-value>loginid</param-value>
     </init-param>
     <init-param>
       <param-name>subjectIdentifierName0</param-name>
       <param-value>loginid</param-value>
     </init-param>
   </source>

The subject source works fine except that in the UI any unicode
characters that appear in any of the fields (eg. 'description') do not
render properly.

If I use the UI to create a group or folder and enter unicode
characters in the name of the group or stem for example, it works
fine.

My database (MySQL) is configured to support UTF-8 and other
applications are working fine when retrieving the same column
information with the same data.

I also updated to the very latest MySQL JDBC jar file to rule out any old 
bugs.

Any ideas?

Thanks,

Scott