The best way to do that would be use Unicode but depending upon your SQL
installation and uses, you might like to consider Collation. However, let
me inform you before hand that you might run into some problems with
collation if you try to export/import data from/to different servers that
don't use the same collation. The best thing would be to use Unicode.

However, if you are interested in Collation, please review the following
links to get you started:

Everything that you need to know about collation
http://msdn.microsoft.com/library/de...us/architec/8_
ar_da_6ttf.asp?frame=true

How to transfer a database from one collation to another collation in SQL
Server
http://support.microsoft.com/default...&Product=sql2k

Sanchan [MSFT]

sanchans (AT) online (DOT) microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.

Sorry, I forgot the main link for Unicode:

http://msdn.microsoft.com/library/de...hart/IntlFeatu
resInSQLServer2000.htm

Please start your search from this link before reading my earlier reply.
Hope this helps.

sanchans (AT) online (DOT) microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.