Re: Display and Store Problem!

From: Addison Phillips [wM] (aphillips@webmethods.com)
Date: Tue Aug 05 2003 - 11:14:48 EDT

Next message: Doug Ewell: "Re: Handwritten EURO sign"

Previous message: Chris Jacobs: "Re: Display and Store Problem!"
In reply to: rajesh@inflibnet.ac.in: "Display and Store Problem!"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Mail actions: [ respond to this message ] [ mail a new topic ]

Hi Rajesh,

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:aphillips@webmethods.com
-------------------------------------------
Internationalization is an architecture. It is not a feature.
Chair, W3C I18N WG Web Services Task Force
http://www.w3.org/International/ws
rajesh@inflibnet.ac.in 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
> =======================================================

Next message: Doug Ewell: "Re: Handwritten EURO sign"
Previous message: Chris Jacobs: "Re: Display and Store Problem!"
In reply to: rajesh@inflibnet.ac.in: "Display and Store Problem!"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2.1.5 : Tue Aug 05 2003 - 12:02:35 EDT