Hi Patrick, Patrick Beunaiche [mailto:[EMAIL PROTECTED] wrote: > > I have created a new MAXDB database with UNICODE type. > I downloaded the contents of the ASCII Maxdb database to be > migrated by > specifying CODETYPE=UCS2 in the command file (.cmd). > Right now, I am trying to load the contents of the files data0000 and > data0001 into the UNICODE database. > > But I am encountering the following issue : > > SET CODETYPE UCS2 > Successfully executed > TABLELOAD USER DATA INSTREAM FILE 'tmp/data' > Error during execution > -->-25347 > Encoding type of source and target database do not match: > source = ASCII, > target = UNICODE. > You can't use the TABLEEXTRACT/TABLELOAD command of the Loader (which implicitely sets the external data file format to PAGES) to migrate the data from ASCII to UNICODE. Using this format the Loader simply copies DB Pages from one DB to another. There is no chance of migration from ASCII to UNICODE here.
> In the data0000 file I can see the "ASCII" string is present > though I set > CODETYPE to UCS2 during the download from ASCII database and > the load into > the UNICODE database. Is it the reason why i am encountering the issue > described above ? > > One extracted line of the data0000 file : > > "SOPRANO","ACCOUNT","2","? ","? > ","? > ","? > ","data0001","FILE","?","PAGES","ASCII","0","74752","0","13209 > 6","0","0" > What version of the Loader do you use? You could use the external file format RECORDS for migration from ASCII to Unicode. Depending on the version the Loader itself detects the encoding of the database and adapts the file encoding. Your commands would look similar to the ones you used except of the format specification: TABLEEXTRACT USER DATA OUTSTREAM FILE 'your file name' RECORDS and TABLELOAD USER DATA INSTREAM FILE 'your file name' RECORDS Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
