Char or Varchar are enough to support both English and French. The N is for Unicode and takes twice the size (ie a char(10) takes 20 chars).
>If we want to save English and Frech in the field of table, should we set the field data type as Char or nchar?
>
>Which way is better?
>
>
>Thanks
>
>
>Jim Hou
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com