BO Universe Prompt doesn’t filter Multi byte Characters – Crystal Reports

A lot of times we create crystal reports on Business Objects Universes. We use the condition objects with @prompt to filter out data on particular columns. Sometimes we have multi byte characters in Databases like Japanese, Chinese characters which don’t get filtered properly unless the IsUnicode radio button is enable.

So for Reports built for multiple languages, this radio button is pretty mandatory. Also enable the Property IsUnicode at the universe parameters to be on the safer side. This appends an ‘N’ before fields of nvarchar datatype.