Re: Informix/ODBC/Text datatypes

Posted in 1997

William Harris — 3 Jun 1997 15:44:37 GMT — source: Informix-list mailing list archive (1991-1998)

In article <5muu7e$9a9@news1.ni.net>, billb@connect3.com says... >Text datatypes in Informix 7.13 don't seem to be very ODBC friendly. We're >a client/server software developer working mostly in C++. We are exploring >other RAD tools such as PowerBuilder for some of our less complex >maintenance functions. None seem to handle Text datatypes gracefully ... >any kind words on this topic would be greatly appreciated ... Some ODBC drivers handle it more gracefully than others. Either Visigenics or Intersolv (apologies, I don't remember which) lets you do a simple "select txt from xxx where ..." and manages Informix's onerous text field processing behind the scenes for you. Others can handle it as long as it's a parameterized prepared statement, with the text field as a parameter. -- William Harris william@carsinfo.com