----- 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]

Reply via email to