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
