Red Gate forums :: View topic - Corruption of accented characters using Packager 6.6.0347
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

Corruption of accented characters using Packager 6.6.0347

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
chris.king@uk.g4s.com



Joined: 01 May 2013
Posts: 1
Location: Leicester, UK

PostPosted: Wed May 01, 2013 10:58 am    Post subject: Corruption of accented characters using Packager 6.6.0347 Reply with quote

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?

TIA,

Chris King
Back to top
View user's profile Send private message Send e-mail
Chris.Allen



Joined: 12 Mar 2009
Posts: 593

PostPosted: Thu May 02, 2013 2:03 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group