ascii equivalent in 9.40
Hello, If i do select ascii("E") from table_name on IDS 11.10 ( db_locale en_us)i get some constant output. But when i do select ascii("E") from table_name (same table as that in 11.10) on IDS 9.40 (LANG=de_DE.UTF-8) i get message as 674: Routine (ascii) can not be resolved. Please guide Is there any equivalent function to ascii in 9.40, does it has to do any thing with the locale for the db. Please HELP ! Thaanking you all Vikas.
is ascii() is valid for 8Bit ASCII characters, UTF8 are 2 Byte characters. Joerg Volz ________________________________ Von: ids-bounces@iiug.org im Auftrag von VIKAS HIVARKAR Gesendet: Do 17.04.2008 18:34 An: ids@iiug.org Betreff: ascii equivalent in 9.40 [11875] Hello, If i do select ascii("E") from table_name on IDS 11.10 ( db_locale en_us)i get some constant output. But when i do select ascii("E") from table_name (same table as that in 11.10) on IDS 9.40 (LANG=de_DE.UTF-8) i get message as 674: Routine (ascii) can not be resolved. Please guide Is there any equivalent function to ascii in 9.40, does it has to do any thing with the locale for the db. Please HELP ! Thaanking you all Vikas. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: 07841-681651 Fax: 07841-681654 Mobil: 0170-2989757 Ust-ID: DE201383541 http://www.it-volz.de
On Thu, Apr 17, 2008 at 9:34 AM, VIKAS HIVARKAR <vikashivarkar3@gmail.com> wrote: > If i do > select ascii("E") from table_name on IDS 11.10 ( db_locale en_us)i get some > constant output. > But when i do > select ascii("E") from table_name (same table as that in 11.10) on IDS 9.40 > (LANG=de_DE.UTF-8) i get message as 674: Routine (ascii) can not be resolved. > > Please guide That's something to do with the fact that the routine was added after 9.40 was released... > Is there any equivalent function to ascii in 9.40, does it has to do any thing > with the locale for the db. Back in 2005, I believe I posted some code to provide ASCII functionality. It is designed around single-byte codesets, and won't work so well for UTF-8, though. Look for a file 'ascii.tgz', possibly in the IIUG Software archive. Or look for files 'ascii.unl', 'ascii.sql', and 'asciitbl.sql'. 'chr.sql', and 'mkascii.sql'. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.