Tag Info

New answers tagged


You can edit the dump file and change the included NLS_LENGTH_SEMANTICS from BYTE to CHAR. Near the beginning of the file you find a line ending like this : ^@02:00:^@^@^D^@BYTE^F^@UNUSED^A^@2^K^INTERPRETED^K^@DISABLE:ALL^@^@ Change BYTE to CHAR using your favorite text editor and save the file. When you will imp that new dump file, all columns will be ...


Converting columns: ALTER TABLE table_name MODIFY col_name VARCHAR(100) CHARACTER SET utf8; Converting tables: ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;

Top 50 recent answers are included