Re: LOAD DATA INFILE and BIT columns

2006-02-27 Thread Julie Kelner
n to write '2' as binary data. And...it worked! Thanks so much for your input. ~ Julie - Original Message - From: "sheeri kritzer" <[EMAIL PROTECTED]> To: "Julie Kelner" <[EMAIL PROTECTED]> Cc: Sent: Monday, February 27, 2006 12:50 PM Subject:

LOAD DATA INFILE and BIT columns

2006-02-24 Thread Julie Kelner
Hi. I'm using MySQL 5.0.18, and I'm trying to use LOAD DATA INFILE into tables that have BIT(8) columns. No matter what format I use, the result is not what I expect (see example below.) Anyone know how to properly format the data for loading into a BIT column? Thanks! $ cat /tmp/bit_test.txt 0