Re:

Anil Dont know for sure if this will help, but you could try setting the DB_LOCALE on the server to the appropriate german char set. HTH Sujit Anil Kulkarni <anilk@ltitl.co.in> on 07/01/99 02:48:55 AM To: "'informix-list@iiug.org'" <informix-list@iiug.org> cc: (bcc: Sujit Pal) Subject: Hi, We are developing a web based castalog and ordering system. The client part is written in Java (VJ++ 6.0) and back end is Informix Dynamic Server 7.3 and Informix JDBC 2.0 driver . We are accessing the database which has a data in German Language. We want to give the facility of sorting the data on the client using the German characters i.e we want the sorting to be carried out in Localised order and not based on the Code set. For this we have made the necesasary changes in the datatypes of the strings (from varchar to nvarchar) We tried DB_LOCAL and CLIENT_LOCALE parameters for the JDBC Database URL string but it doesnot seem to work. The sort order that we are getting is still based on 8859-1Code set and not on Cp273 Code set which specifies German Characters. We used the following url to connect to the database using JDBC 2.0 driver java LocaleDemo jdbc:informix-sqli://dbsvr:1526/wukorelease:informixserver=wukodbsvr;user=i nformix;password=informix;CLIENT_LOCALE=de_de.Cp273;DB _LOCALE=de_de.Cp273 The DB_LOCALE on the Informix Server host (NT Server) is en_us.1252. Are we missing out on anything? How do we make use of the Java's Internationalization features here? Any information on the above will be appreciated. Thanking you in advance, Regards -- Anil Kulkarni. L&T Information Technology Ltd., Pune, India. Tel : 91 20 5530813 http://www.ltitl.com