----- Original Message ----- From: "walt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 31, 2004 12:17 PM Subject: specify data type in select statement
> We've run into a problem where binary char column types crash our c++ > application when migrating from RedHat 7.3 to RedHat ES. Is there a way to > specify the data type to be returned in the select statement. In the below > example, selecting office_id will crash the app if it's left as a binary > column. > > I'm looking for something like > select char<office_id> from office; > > > create table office ( > office_id char(8) binary not null, > office_name varchar(50) ); > Have a look at the Cast() and Convert() functions. They are described at http://dev.mysql.com/doc/mysql/en/Cast_Functions.html. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]