[megoldva] Oracle karakter kódolási probléma sql file betöltésekor

Sziasztok,

Előre is bocs a kezdő kérdésért...

Van egy oracle 11g és egy sql file amit szeretnék beimportálni. File UTF-8-as kódolású.
Az NLS_CHARACTERSET AL32UTF8.
A problémám a következő: ha simán @filnev-el töltöm be az sql filet, akkor rossz lesz a kódolás, ha sql developerből, akkor meg jó.
Hogy tudnám ezt megoldani?

A LANG változó a szerveren en_US.UTF8. Az sql developer egy magyar windowsról fut.

Köszi,
Sz.

Hozzászólások

4.4.5 About Running Oracle Application Express in Other Languages

The Oracle Application Express interface is translated into German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese, and Traditional Chinese. A single instance of Oracle Application Express can be installed with one or more of these translated versions. At runtime, each user's Web browser language settings determine the specific language version.

The translated version of Oracle Application Express should be loaded into a database that has a character set that supports the specific language. If you attempt to install a translated version of Oracle Application Express into a database that does not support the character encoding of the language, the installation may fail or the translated Oracle Application Express instance may appear corrupt when run. The database character set AL32UTF8 supports all the translated versions of Oracle Application Express.

You can manually install translated versions of Oracle Application Express using SQL*Plus. The installation files are encoded in AL32UTF8.

Note:
Regardless of the target database character set, to install a translated version of Oracle Application Express, you must set the character set value of the NLS_LANG environment variable to AL32UTF8 prior to starting SQL*Plus.

The following examples illustrate valid NLS_LANG settings for loading Oracle Application Express translations:

American_America.AL32UTF8
Japanese_Japan.AL32UTF8

http://docs.oracle.com/cd/E10513_01/doc/install.310/e10496/db_install.h…

Google 2 perc alatt

===============================================================================
// Hocus Pocus, grab the focus
winSetFocus(...)

http://c2.com/cgi/wiki?FunnyThingsSeenInSourceCodeAndDocumentation