How to set to UTF-8 encoding for information that include in script?
869955Dec 22 2011 — edited Dec 22 2011Hello to all!
I have many .sql files. The first one is 0.sql. From SQL Worksheet I type:
@0.sql;
The problem is, that all information, that is in .sql files, is inserted into database in ANSI encoding, but I need UTF-8.
For example when I copy information into Worksheet from .sql files for example:
INSERT INTO tmp_KL002 (K, N) VALUES ('00', 'nav zināms');
Then I get in database all right - nav zināms.
When I launch script @0.sql, I get - nav zin�ms in databse.
Please help me, how to correct this? I tried to change SQL Developer configuration, but that do nothing. Maybe you know
the answer for this question?
Thank you!