Import Export to sql problem

[ivog]

Hi,

I'm exporting a table containing some encrypted strings using export to sql inserts. When i import the generated sql script back into the original table the result aren't the same as the original.

I'm guessing this has something to do with encoding but it seems to me a export followed by an import into the same db should give me the same results.

I'm using 7.0.3.11.23 and sqlplus

 

[Marco Kalter]

Can you let me know what the differences are?

 

[ivog]

When i query the column in sqlplus the value before import is:
☻

 

[Marco Kalter]

This may be a client/server character set compatibility issue. If the server data cannot be represented in the client character set (NLS_LANG), exporting and importing may lead to different results.