Re: Importing a separated file into mysql, national charset problem??

2005-02-13 Thread Petr Vileta
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

Re: Euro Symbol (€)

2004-01-19 Thread Petr Vileta
| 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/[

charsets

2003-03-07 Thread Petr Vileta
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