How to insert French chars into SQL Server 2000?

[blexman]

I would like to create a cross reference table with 3 columns :

key field, english_translation, french_translation

How do I create this table so that the french_translation column is defined as French chars ?

thanks
hanton

 

[skuhlman]

No SQL defenition would define explicitly french characters. I think that you're wanting to use NCHAR or NVARCHAR for your field type instead of CHAR or VARCHAR. The N... field types will accept unicode/foreign characters.

 

[blexman]

Skuhlman, do I have to change/set the collation for the French column ? ; I don't care much about sort order.

 

[skuhlman]

not sure, but I don't think so