specify data type in select statement

2004-08-31 Thread walt
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

Re: specify data type in select statement

2004-08-31 Thread V. M. Brasseur
Perhaps a casting function would help you: http://dev.mysql.com/doc/mysql/en/Cast_Functions.html If case-sensitivity isn't an issue, you may want to consider converting from char(8) binary to just char(8). Cheers, --V walt wrote: We've run into a problem where binary char column types crash our

Re: specify data type in select statement

2004-08-31 Thread Rhino
- 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