I'm having an issue with MySQL or the MySQL ODBC driver. I'm trying to write data to a MySQL column thats set VARCHAR(15) from a seperate windows 2003 machine. The connection works and data is written to the proper column however the rows aren't advancing properly. After I write the data to the database I can see that data is being written to the limit of the field (15 characters) and then some crazy string is being written (ýÿÿÿ) and then the next field is inserted. Here's an example of a bunch of IP addresses being written into mysql with each line reqresenting another row:
Quote:
c-ip
24.110.126.171
ýÿÿÿ69.163.199.
108
55.20
.143.153.129ýÿÿ
ÿ172.150.236.21
0ýÿÿÿ63.207.131
.62
0.236.210ýÿÿÿ68
.202.132.119
|
Anyway, does anyone know what could be causing this problem? The data is coming out of Log Parser 2.2 on the windows machine and displays properly when I dump it to the screen or a text file from the CLI. LP 2.2 doesn't throw any errors during the dump either.
Thanks,
Ryan
Linear Mode
