Corruption of accented characters using Packager 6.6.0347

Forum for users of SQL Packager database archive utility

Corruption of accented characters using Packager 6.6.0347

Postby » Wed May 01, 2013 9:58 am

Hi Folks,

I have a SQL Script that I am attempting to package that is currently 239, 343 lines in length.

The majority of this is reference data so that data script generated by the packager is about 85% of the total length.

My source script contains both English and French text and this includes accented characters such as é.

When I install from my source script to a SQL 2012 instance, the accented characters are preserved but when I package the script into an .exe using Packager the resulting installation has replaced the accented characters with question marks.

Has this behaviour been observed before? Is there anything I can do to prevent this?


Chris King
Posts: 1
Joined: Wed May 01, 2013 8:56 am
Location: Leicester, UK

Postby Chris.Allen » Thu May 02, 2013 1:03 pm

This is usually a function of the underlying text encoding (for example ANSI vs Unicode (UTF xx).

*My* way of solving this is, using a free text editor such as Notepad ++, check the encoding of the original text files- test if it works better when they are all UTF or all ANSI.

I hope that helps.
Posts: 579
Joined: Thu Mar 12, 2009 3:17 pm

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests