Raghu,If your target database code page is UTF-8, any character data that is being passed to DB2 will get converted to UTF-8. There are various other factors to consider for improving performance, DB2 client/serverside conversion, bind/execution conversions, coding stored procedures etc. One other factor to consider is that your application code page should have a DB2 supported mapping for successful code page conversions (SQLCODE -332). Implementing NLS support is a whole topic by itself and we can discuss this offline if you wish. Regards, Ajith
-----Original Message----- From: Raghu Raman [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 5:17 PM To: [EMAIL PROTECTED] Subject: RE: [DB2EUG] UTF-8 SBCS, MBCS - Support Hi Ajith, You mean in my select statement I don't need to convert but just pass the parameter and DB2 will take of converting right. Regards, Ragu -- On Thu, 11 Apr 2002 15:49:45 Vilas, Ajith (USPC.PCT.Hopewell) wrote: >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 > > 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
