54952

Oracle: possible encoding problems when importing data

Question:

On Oracle 11, I dumped my data using exp/imp to be migrated to another DB.

I tested to import the dump file on my local database, with no problem at all.

But then my colleague tried the same on his own machine and <strong>some tables</strong> couldn't get imported due to the error:

can bind a LONG value only for insert into a LONG column.

I dont have any long type, but I read that this error could also be thrown when size exceeds on a varchar2 type, So I checked character sets of databases, I have default Windows charset and he has utf8 charset. So do you think maybe same length of data are represented with more bytes and this leads to this kind of error?

Do I have to change my database charset and create another dump? I look for a better solution, because this also needs to be imported to customers database, which I know has a totally different charset..

Answer1:

Any windows inherited character set isn't multi byte by definition. When you created multi byte(utf8) db every single character may be converted during the import to 1-3 bytes. So you have to increase automatically before import every string type column to x3 times. In case you will case the limit of 4096 use Clob type instead.

Recommend

  • how to sort tuple element first on the basis of key and then on the basis of value [duplicate]
  • Configure Capybara to use Marionette WebDriver for Firefox
  • TypeError: winston.Logger is not a constructor with winston and morgan
  • Programmatic hibernate configuration after xml configuration
  • What to do after getting Auth Token - Android Youtube API
  • Where can I find tomesh.c for windows?
  • Passing Objects to fragment without argument
  • JavaFX TabPane System like in a browser
  • Simulating argparse command line arguments input while debugging
  • How to customize marker colors and shapes in scatter plot?
  • GLSurfaceView Zoom(PINCH ZOOM)
  • IIS - ASP.NET MVC redirection
  • Why is this Animatable property being set again?
  • Identify File Type in Java
  • Alternating edit text hint not visible for Arabic language
  • reverse array in place
  • Arc gradients in Flutter?
  • Bazel failed to include a external static library .a
  • How to add ng-app after page load?
  • Validating a Firebase Key [duplicate]
  • Jekyll - How do I create pages in the root directory?
  • Java 11 and E(fx)clipse JavaFX plugin on Eclipse 4.9: An error has occurred - see the log file
  • .htaccess redirect domain.com to www.domain.com
  • android : speech recognition what are the technologies available
  • $this->a->b->c->d calling methods from a superclass in php
  • Implementation of timeout in LDAP
  • System.Drawing.DrawString() weird wrapping of long string
  • Facebook Error (#200) The user hasn't authorized the application to perform this action (PHP)
  • What are advantages/disadvantages of using Selenium for Java vs .NET applications?
  • Java Collections.shuffle() weird behaviour [closed]
  • How convert html to BBcode in C#
  • Zoho API: Get the user that is making the request
  • C++ STL stack pop operation giving segmentation fault
  • How do I add a mouse over tooltip to an Image using .DrawImage()
  • Another “Cannot make static reference…” Question
  • Google App Engine Datastore: Dealing with eventual consistency
  • Update cell query for Excel ADO from Delphi
  • ssh remote server login script
  • How to call different template for different category archive page in woocommerce
  • Angular 4: Responsive Grid List