Internal column names: Site Columns vs List Columns

Two identical custom lists with the same columns. The only difference is that one list has columns added using Site Columns and the other list had columns added directly to the list. The same? Not so much…

Steps to repro this issue:

  1. Create a site column named “A,B-C/D” (single line of text or any other type)
  2. Create a list named “Special Characters (Site)”
  3. Add the Site Column “A,B-C/D” to your “Special Characters (Site)” list.
  4. Create another list named “Special Characters (List)”
  5. Create a column in “Special Characters (List)” named the same as your site column (“A,B-C/D”)

Results:

  Column Added Using Site Column Column Created Directly in the List
Column Name A,B-C/D A,B-C/D
Internal Column Name A_x002C_B_x002d_C_x002F_D A_x002c_B_x002d_C_x002f_D

The internal column names are DIFFERENT.

… but only for some of the characters. Looks like the comma and the slash are different but not the dash.