2) ) I
define as VARCHAR with the same length.
2) I load data into temporary table using LOAD DATA INFILE
3) I convert all "numeric" values using
UPDATE TABLE temptable SET numeric_field=REPLACE(numeric_field, ',' ,
'.')
4) I load (or append) data from temporary table
| PRI | | |
+--++--+-+-+---+
Test to use varchar(5) binary field type for CYSYMBOL field (if you store
symbols here).
Petr Vileta, Czech republic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
I have mysql 3.23.55 for Windows where charset "win1250ch" is included. Now
I download the same version for Linux (rpm) but this charset is not included
here. Why?
Thank you for your quick reply.
Petr Vileta, Czech Republic
http://www.pra