non ASCII characters in text column

Posted in 2003

rkusenet — Sat, 15 Nov 2003 09:12:55 -0500 — source: Usenet: comp.databases.informix

we have a text column and a requirement has come from a particular user that it should contain text in encrypted form. now the encrypted text will contain non ASCII characters. Is it possible for the text column to store one row in ASCII text and another row in non-ASCII text. Will it have any repercussions. Thanks. Ravi

↪ replying to rkusenet

Paul Watson — Sun, 16 Nov 2003 08:54:12 +0000 — source: Usenet: comp.databases.informix

You coulld uuencode the 'non text' text column rkusenet wrote: > > we have a text column and a requirement has come from a particular user that it > should contain text in encrypted form. now the encrypted text will contain non > ASCII characters. Is it possible for the text column to store one row in ASCII > text and another row in non-ASCII text. Will it have any repercussions. > > Thanks. > > Ravi -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to rkusenet

Christian Knappke — 17 Nov 2003 13:46:18 GMT — source: Usenet: comp.databases.informix

On 15 Nov 2003, "rkusenet" <rkusenet@sympatico.ca> wrote: > we have a text column and a requirement has come from a > particular user that it should contain text in encrypted form. > now the encrypted text will contain non ASCII characters. Is it > possible for the text column to store one row in ASCII text and > another row in non-ASCII text. Will it have any repercussions. Yes, it is possible. SAP systems like R/3 store a lot of binary data in mere CHAR columns. HTH Christian -- #include <std_disclaimer.h> /* The opinions stated above are my own and not necessarily those of my employer. */