Search code examples
sqlinstallshield

Language issues when running SQL statements from installshield

I have an installshield installation that connects to a SQL Server instance and inserts words from different languages.

After the import runs When I query the data from the database characters from languages with different alphabets are showing up as jumbled text. An example of this would be Russian.

It turns into Ð¡Ñ‚Ð°Ñ‚ÑƒÑ instead of the correct Russian characters.

How can I fix Installshield so that it inserts the text correctly?

Solution: from Panagiotis Kanavos

I forgot to add the N before the strings. EG N'[Russian text]'

Solution

  • From the characters (regular pairs,same first character), it looks like UTF16 text was stored as single-byte text in the database. Did you forget to add the N prefix in front of any Unicode literals perhaps?