Menu
My problem is that my PL/SQL developer doesn't show "ő" characters. Instead it shoes "o".
First I thought that there is problem with the localization, but the system locale, and the location is good too(It is set to Hungary).
The Database supports ő characters my team mates can see the characters. I copied their configuration to my PL/SQL developer, still I can't see the "ő" character.
I checked at Tools->Preferences->Options that "Unicode enabled" is checked.
What can be the problem? I am still thinking that some setting is bad in windows.
342
To do this, execute the query select ascii('🍁') from dual; To get the character (such as 🍁) into the query code, you need to somehow copy it and then paste it into the code editor in SQL Developer. The way I do this is to copy the character from one of many sites on the Web that lists Unicode characters.
Use braces to escape a string of characters or symbols. Everything within a set of braces in considered part of the escape sequence. When you use braces to escape a single character, the escaped character becomes a separate token in the query. Use the backslash character to escape a single character or symbol.
SQLDeveloper has an option to change the Encoding of database files (e.g. . sql files). This can be done from Tools -> Preferences -> Environment -> Encoding.
You can replace special characters using the Oracle REPLACE function. To replace both carriage return and new line characters, you must use nested REPLACE functions. If you want to replace a lot of special characters, using many nested REPLACE functions can get messy and could have performance impacts.
try to change your NLS_LANG in your regedit to HUNGARIAN_HUNGARY.EE8MSWIN1250 or somthing like that.
100
If you are using PLSQL Developer with instant client - you must set the NLS_LANG manually.
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
