text column into char or varchar variable

Posted in 2008

SHAN SALEON — Wed, 23 Jan 2008 09:02:54 — source: IIUG Forums & Mailing Lists

Hi, every, I want to get the column value, datatype is text,how can I get this column into a char variable. thanks.

↪ replying to SHAN SALEON

Sheshnarayan — Wed, 23 Jan 2008 09:17:24 — source: IIUG Forums & Mailing Lists

What's your application? Is it using ODBC? If so, you can simply use SQLGetData (with SQL_C_CHAR) as C type. You can also use SQL_C_WCHAR to get data in Unicode (if you have data stored in TEXT column in multi-byte per char) !! -Shesh "SHAN SALEON" <shanshl@msn.com> Sent by: ids-bounces@iiug.org 23/01/2008 14:32 Please respond to ids@iiug.org To ids@iiug.org cc Subject text column into char or varchar variable [11061] Hi, every, I want to get the column value, datatype is text,how can I get this column into a char variable. thanks. ******************************************************************************* 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!!

↪ replying to Sheshnarayan

SHAN SALEON — Wed, 23 Jan 2008 10:26:29 — source: IIUG Forums & Mailing Lists

i use it in store procedure.