Can someone tell me how to import tables in ASCII version to MySQL?
Thank you
Define "ASCII version": CSV, tab-delimited, SQL file, etc.?
they said "data is published in Windows 8-bit ASCII format (Windows Code Page 1252)."
get a file, post a line. Telling you that it is windows 8-bit tells you something about the bytes, but nothing about the content structure
the file is data.txt and the content is something like this:
A_IDTRACKTR_ARTICLECOMPOSERMEDIANUMTRACKNUMTIMET_IDCHANGE_CDR 950425Zita PassaLa113:16T 9952076AR 950425I Biondi Capelli123:10T 9952077AR 950425Pizzica133:43T 9952078AR 950425Ninna Nanna143:13T 9952079AR 950425Tarantella Di Masaniello152:25T 9952080AR 950425Lu Cacciatore Gaetano162:15T 9952081AR 950425Schiattate Gente Né177:13T 9952082AR 950425Ciatu Meu182:07T 9952083AR 950425Vicariota193:32T 9952084AR 950425Tarantella1101:32T 9952085AR 950425Angelaré1112:57T 9952086AR 950425PrucessioneLa1123:13T 9952087AR 950425Tarantella Di Via Ludovisi1131:59T 9952088AR 950425PescecaneLo1142:04T 9952089AR 942635Java11T 9952090AR 942635Boy Meets Horn12T 9952091AR 942635Mack the Knife13T 9952092AR 942635Do You Know What It Means to Miss New Orleans14T 9952093AR 942635Look Down That Lonesome Road15T 9952094AR 942635Best Things in Life Are FreeThe16T 9952095AR 942635Bourbon Street17T 9952096AR 942635Parade18T 9952097AR 942635And the Angels Sing19T 9952098AR 942635Night in TunisiaA110T 9952099AR 942635Tenderly111T 9952100AR 942635I Can't Get Started112T 9952101AR
Looks like it's probably a tab-delimited file, but create in MSWord or such, making it very non-portable. :rolleyes: You might try opening up the original file in Word, then doing a "Save As" as a plain ASCII text file.
the problem is.. the size of the file is 3gb
btw what is mean?
nagasea wrote:btw what is mean?
I believe it's just an indication of some character that cannot be displayed via the current character set.
