Text import

[lag]

Hi,

When I use Text import, the symbole "霢 apear instead of "

 

[Marco Kalter]

That looks like Unicode. Maybe this is an environment problem. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[lag]

Hi,

find support info.

Best regards

--- Info ---

PL/SQL Developer
Version 7.1.1.1339
01.42593 - 1 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Language: Fran

 

[lag]

Could you please help me about this ?

 

[lag]

When I made UTF8 instead of Autodetect, it's work.

I think autodetect don't kork proprely.

Best regards

 

[Marco Kalter]

We'll check it out.

 

[petke]

Hi Marco!

Do you have any recommended way to import unicode text, or even an excel file (with unicode content) by using plsql-developer?

I've tried several ways, but I was unable to load my data into database correctly. (via text importer, via odbc importer...)

My NLS_LANG setting is corresponding to my OS EE8MSWIN1250. I've enabled unicode support in pl/sql dev. Oracle client is 9.2.0.6. Certainly DB supports unicode (or double byte Latin2 8859-2) , 'cause its charset is UTF8.

Any help is appreciated.

BR, peter

 

[Marco Kalter]

Assuming you use version 7.1, the text importer should be able to import Unicode. Does the text appear correct in the preview?

 

[petke]

Unfortunately it doesn't.
If I create a text export (ie. from ms excel), only the "unicode text" contains the correct contents.
But that file is totally unreadable by your text importer. It only shows "

 

[petke]

I can send a sample file via email to help your investigation, and a requested result also.

Please let me know if you need those files.

 

[Marco Kalter]

Yes, please send me the files.

Can you also go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[FrankMUC]

Hi,
I am very interested on the solution of this problem too: How to get UNICODE out into a text file (a script) and how to load this data into a database table?
Regards Frank