SQL Server 2005 multiple languages/characters

benoitmarcotte
benoitmarcotte used Ask the Experts™
on
Is it possible to store multilple languages/characters (romance, russian, arabic, chinese) in the same column of the same table in sql server 2005? if yes, what should I look into?

Thanks
n/a

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AneeshDatabase Consultant
Top Expert 2009

Commented:
datatype - nvarchar and choose a collation to the one matching the language
AneeshDatabase Consultant
Top Expert 2009

Commented:
if you want to store multiple languages on the same column go for the nvarchar

Author

Commented:
Thanks. I did nvarchar but I have a limited number of collation and don't know which one I should choose.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
it should be multiple languages in the same column. Is there a collation that could accomodate that?
AneeshDatabase Consultant
Top Expert 2009

Commented:
None of the collation settings affects the way data is stored. They only determine how it is compared and sorted.
http://technet.microsoft.com/en-us/library/ms143726(SQL.90).aspx

Author

Commented:
thanks again. I tested one entry submitted in Arabic so far and what is stored in the db are a string of interrogation marks. I take it that the problem isn't with the field settings in the db but in the coding of the ASP or the server configuration?
AneeshDatabase Consultant
Top Expert 2009

Commented:
it is encoding from the ASP

Author

Commented:
so should I ask the question to ASP people or do you have any idea what I should be looking at in the ASP?
Database Consultant
Top Expert 2009
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial