Some languages are not displayed correctly with MS SQL Server after contents are saved and liferay is restarted

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP1 (5.2.5)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP2 (5.2.6)
• Component/s: None
• Labels:
  • 5.2_release_notes
• Environment: all

Some languages like Israeli and Turco are not displayed correctly when contents are stored in MS SQL Server with char, varchar, text as data type.
After changing the data types to nchar, nvarchar, and ntext, which is SQL Server specific for unicode data, contents are stored and displayed correctly.