It was easier than I think!
Field "DATAPROD" is dbf has only 8 symbols length. I set 50 symbols for this field and it works!
Now I have another problem with cyrillic encoding. )
JavaJunior
Last Activity: Oct 22 '07, 11:01 AM
Joined: Oct 16 '07
Location:
-
sorry, I mean data in DATAPROD column in mysql table look like datetime: 'Wed May 02 00:00:00 MSD 2007', but it type is varchar....Leave a comment:
-
What do you mean "using TO_CHAR" - make field CHAR type, or something else?
I think the problem is in converting DBase type "Date" into MySQL type "Datetime". And another one problem in converting russian letters from *.dbf into MySQL table. I create mysql table with DEFAULT CHARSET=utf8....Leave a comment:
-
The type of 'DATAPROD' in *.dbf file is Date (like 02.02.2007) and it will be VARCHAR in MySQL...Leave a comment:
-
MySQL version is 4.1.
SQL statement is:
insert into ALEX (DATATIME,DOCTY PE,DOCNUM,STRNU M,KODNOMEN,NOME NKLAT,EDIZM,DAT APROD,KOLVO,VES ,CENA,SEBEST,KO DKLIENTA,KLIENT ,FILIAL) values ('02.05.07 08:45:15','®¢ ï á室* ï ª« ¤* ï','7063','1',' 00048','‘ªã¬¡à¨ ï â«.å/ª ¡/£ ¨§ áëàìï 400-600','ª£','Wed May 02 00:00:00 MSD 2007','12.9','1 2.9','132.3','1 150.94','000013 06','„¥¬ìï*®¢ ..','€«¥ªá¥¥¢ ª ')...Leave a comment:
-
Hi,
I have the same problems when I try to convert data from *.dbf to MySQL table:
Exception in thread "main" com.mysql.jdbc. MysqlDataTrunca tion: Data truncation: Data truncated for column 'DATAPROD' at row 1
at com.mysql.jdbc. SQLError.conver tShowWarningsTo SQLWarnings(SQL Error.java:717)
at com.mysql.jdbc. MysqlIO.scanFor AndThrowDataTru ncation(MysqlIO .java:3102)
at com.mysql.jdbc. MysqlIO.sqlQuer yDirect(MysqlIO .java:1862)...Leave a comment:
No activity results to display
Leave a comment: