Unless you are using nchar/nvarchar fields for your data, SQL Server is using a specific code page (non-Unicode character set) to store your data. It is likely that this is Cp1252 (Western European).
If you switch to nchar/nvarchar fields your mapping issues will go away. I have a paper that describes some of these issues on the webMethods website (it's "Creating Multi-lingual and Multi-locale Databases") here:
http://www.webmethods.com/cmb/solutions/solutions_white_paper_email_entry/
Best Regards,
Addison
-- Addison P. Phillips Director, Globalization Architecture webMethods, Inc.
+1 408.962.5487 mailto:[EMAIL PROTECTED] ------------------------------------------- Internationalization is an architecture. It is not a feature.
Chair, W3C I18N WG Web Services Task Force http://www.w3.org/International/ws
[EMAIL PROTECTED] wrote:
Dear professionals,
kindly help me.
My application is developed by using the JDK1.4 (Swing) on windows 2000 platform with Arial Unicode MS font. RDBMS used for data stores is MS SQL 2000.
My problem is when I insert data in hindi language through the application into RDBMS, it stores in some different characters, but when I retrieve data by puting any query, it retrieves on screen of the application appropriately. But, when I insert data in RDBMS directly (without using application) it stores in appropriate format, but when the same data wants to display by retrieving through the application, it displays in different characters.
Can anyone clarify me the problem?
Thanking you.
=======================================================
Rajesh Chandrakar, STO - I,
INFLIBNET Centre, UGC,
An Inter-University Centre of UGC,
P.B. No. 4116, Navrangpura,
Ahmedabad, Gujarat (India) 380009
Tel. No.: +91 - (0)79 - 6305971, 6304695, 6308528 (O), 6873805 (R)
Fax: +91 - (0) 79 - 6300990, 6307816
Web: http://www.inflibnet.ac.in
=======================================================
