How to specify the encoding for an embedded ressource

[Lucas Bernard]

Hi,

[environment]
Visual Studio 2005
C#

[situation]
In a Class Library project, I have a file (MyScript.sql) containing T-SQL
statements.
The Build Action property of this file is set to "Embedded resource".
In this project, I have a small piece of code whose job is to read the
MyScript file and to execute each sql query.
In a Web Setup project, I have a custom action which access the previous
library.

[problem description]
One of my SQL query looks like this: INSERT INTO ... VALUES ("Mésange").
Unfortunately, once compiled, it is modified to: INSERT INTO ...
VALUES("M?sange").

[my unsuccessful tests]
In the AssemblyInfo.cs of the Library, I have tried different values for
AssemblyCulture(). For example AssemblyCulture("fr").
I have tried to save the file MyScript.sql with different encodings (like
Unicode, UTF8, ....).

[question]
How could I inform Visual Studio to build the dll with the embedded resource
and preserve it's encoding?

Thanks for your time and your answer.
Bernard Lucas