Hi, My database contains English, Arabic and Kurdish data for master tables. User can enter the data in any one of the languages for transaction tables (either any one language only exists) . Data to be retrieved in all languages based on user language selected. Kindly suggest.
Thanks for your reply. I am having the description fields as nvarchar only. But retrieving the data is very difficult. Please find the attached file for the query.![alt text] : /storage/temp/1325-query2.png
I have tried below using multi language and it is working fine. You have to have prefix N for nvarchar, nchar, nvarchar(max) Datatypes to denote national character set. CREATE TABLE languagetest ( identifier INT IDENTITY(1, 1) , langdesc NVARCHAR(30) ); INSERT INTO languagetest ( langdesc ) VALUES ( N'lengthy' ); INSERT INTO languagetest ( langdesc ) VALUES ( N'लंबा' ); SELECT * FROM languagetest where langdesc = N'लंबा';