SQL Script Package Fails with French characters.

Forum for users of SQL Packager database archive utility

SQL Script Package Fails with French characters.

Postby Davy Mitchell » Thu Jan 15, 2009 10:34 am

Hi There,

I have a French SQL Script which has acute accents in it. The Script (ANSI) executes correctly on SQL Server. When Packaged (ver6) it fails. Full trace below but the key bit is 'AUTORITE NT\\SERVICE R�SEAU' - the square should be an e acute - 'AUTORITE NT\\SERVICE RÉSEAU'.

Do I need to save in Unicode or..... ?

Thanks in advance :)

Davy Mitchell

<SQLError Package="French_XP_SRSS"><Error>Windows NT user or group 'AUTORITE NT\\SERVICE R�SEAU' not found. Check the name again.</Error><Assembly>French_XP_SRSS</Assembly><Package>Package1.resx</Package><Batch>Batch2</Batch><SQL>CREATE LOGIN [AUTORITE NT\\SERVICE R�SEAU] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]</SQL></SQLError>
Davy Mitchell
Posts: 14
Joined: Wed Oct 15, 2008 1:41 pm
Location: Scotland

Postby Chris Auckland » Thu Jan 22, 2009 4:14 pm

Thanks for your post.

Unfortunately this is an issue with ANSI scripts, we already have a bug open for this case (SC-4198). You should be able fix this issue by encoding the scripts differently, but it seems that you cannot choose the script encoding through the UI. - I have just logged this as a bug with SQL Packager (SPA-505).

However, you can set the script encoding if you run Packager from the command line. You will be able to use your UI project file with the addition of the /scriptencoding option.
Something like: SQLPackager /pr:"MyProjectFile" /makeexe /scriptencoding:Unicode

You can find out more information on using the command line interface in the helpfile:
http://www.red-gate.com/supportcenter/P ... 20Packager

I hope this is helpful.
Chris Auckland
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests