Red Gate forums :: View topic - SQL Script Package Fails with French characters.
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

SQL Script Package Fails with French characters.

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Davy Mitchell



Joined: 15 Oct 2008
Posts: 14
Location: Scotland

PostPosted: Thu Jan 15, 2009 11:34 am    Post subject: SQL Script Package Fails with French characters. Reply with quote

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 Smile

Thanks,
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>
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Thu Jan 22, 2009 5:14 pm    Post subject: Reply with quote

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/Product.aspx?p=SQL%20Packager

I hope this is helpful.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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