MySQL Forums
Forum List  »  Newbie

What's the best way to convert a data type?
Posted by: David Donahue
Date: March 25, 2005 07:00PM

I have a column of type Text in a table, but when my client software (C# .NET application) is calling the SELECT statement, it doesn't seem to know how to handle Text. What's the best way to convert the column to a Char or something like that in the SELECT statement?

I tried CAST(column_name AS CHAR) but it doesn't seem to be actually casting if more than one record is returned (works fine for just one record though). Any ideas?


Regards,
David P. Donahue
ddonahue@ccs.neu.edu

Options: ReplyQuote


Subject
Written By
Posted
What's the best way to convert a data type?
March 25, 2005 07:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.