I wrote a cold fusion script to migrate data from an access 2000 db to a mysql 4.0.18 db and when I display the data with cold fusion I see these little box characters in different spots.
I'm assuming that it's an issue with the encoding. How do I correct this?
Looks like you might have some garbage characters in the data for one reason or another. First find out what characters those are:
mysql -e "select garbage_col from t" > /tmp/garbage-col.txt then view the file in a hex editor
Once you know the trouble characters:
update t1 set garbage_col = replace(garbage_col,char(garbage_ascii),'')
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
