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
<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>