How to convert oralce chr() function to informix

Posted in 2008

CHUAN LU — Wed, 20 Aug 2008 11:08:39 — source: IIUG Forums & Mailing Lists

Hi, oralce has chr() function, informix has no this function. in oralce chr(65) return 'A', char(66) return 'B' do anybody know how to write this function in informix ? thanks.

↪ replying to CHUAN LU

Fernando — Wed, 20 Aug 2008 14:24:18 — source: IIUG Forums & Mailing Lists

Hello, There is a small collection of SQL scripts that can implement the CHR() function... They were made by Jonathan Leffler and are available at: http://www.iiug.org/software/index_all.html But take note that what it does is to load an ASCII table into a database table and then creates the CHR() as a select from this table. I'm not sure if CHR() is codeset sensitive... If you want a specific codeset you can create your own table, or eventually include one more field that specifies the codeset, so that you could support several codesets... Regards, On Wed, Aug 20, 2008 at 12:08 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > Hi, oralce has chr() function, informix has no this function. in oralce > > chr(65) return 'A', char(66) return 'B' > do anybody know how to write this function in informix ? thanks. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...