Raghu, Code page conversions are done based on application code page (derived from the active environment from the connection is made or set by DB2CODEPAGE variable) and the database code page that was assigned when you created the database. DB2 does this conversions automatically (both ways). Regards, Ajith
-----Original Message----- From: Raghu Raman [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 1:54 PM To: [EMAIL PROTECTED] Subject: [DB2EUG] UTF-8 SBCS, MBCS - Support Hi all, We are using DB2 UDB 6.1 on AIX. The code page for the database is UTF-8. When we insert a record into DB2, the document says we can just do it without converting from native to UTF-8, which will be taken care by the database manager. My question is does this hold good for any select statement with a search string or do we need to convert from native to UTF-8 before we add it in the like clause. For example select * from employee where lastname like 'xyz%' Instead of 'xyz' if we have some Japanese characters there, do we need to convert that to UTF-8 or we add just add the Japanese character in the parameter and DB2 will take care of converting them. Any help would be appretiated. Regards, Ragu See Dave Matthews Band live or win a signed guitar http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
