Sasa Posted June 8, 2009 Report Share Posted June 8, 2009 (edited) SQL: load data local infile 'C:\\korpus.csv' into table korpus fields terminated by ',' enclosed by '' lines terminated by '\n' (thicknes, name, code) CSV: 1,a,4 2,b,5 Pēc importa ir tā ka tur kur jābūt 1 ir 0, un tā ir ar jebko pirmā ieimportētā vērtība ir 0, bet tālāk viss ir kārtībā, tabulas otrā rindā vair nav 0 bet ir tas kam tur jābūt. Edited June 8, 2009 by Sasa Quote Link to comment Share on other sites More sharing options...
Grey_Wolf Posted June 8, 2009 Report Share Posted June 8, 2009 fails gadijumaa nav UTF-8 ?? jaa jaa tad novaac BOM , jo SQL tachu panjem visu pirmo dalju , tas ir fakstiski 4 simbolus , un xxx1 parveidojot uz INT buus 0 .. Quote Link to comment Share on other sites More sharing options...
Sasa Posted June 8, 2009 Author Report Share Posted June 8, 2009 jā fails bija UTF-8, bet es savā notepad++ BOM simbolus neredzu :( Quote Link to comment Share on other sites More sharing options...
bubu Posted June 8, 2009 Report Share Posted June 8, 2009 Tavs notepads BOM simbolus loģiski ka nerādīs, ja tie tur būs. Atrodi tā opcijās kā noņem tos. Nezinu kā notepad'am++ to dara, bet notepad2, ko es lietoju, BOM simbolus noņem izvēloties File->Encoding->UTF-8 (bez signature). Vai arī atver failu kādā hexeditorā vai tamlīdzīgā programmā, kas rādīs faila saturu pa baitiem. Quote Link to comment Share on other sites More sharing options...
Grey_Wolf Posted June 8, 2009 Report Share Posted June 8, 2009 (edited) bet es savā notepad++ BOM simbolus neredzu :( Un neredzeesi ar, jo tie jau neparaadas...saglabaa vinjus : format -> encode in UTF-8 withaut BOM Edited June 8, 2009 by Grey_Wolf Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.