Oracle SQL Developer not displaying chinese characters properly?
I've been playing with NCHAR datatype for a little in oracle database. I created a table with column NCHAR(50) and then tried to inserted some chinese characters however when I pasted the characters SQL developer is not able to display it properly then when inserted on the column its not able to display it properly as well. The encoding in Environment -> Encoding is set to UTF-8 then NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are set to AL32UTF8 and AL16UTF16 respectively. How come its still not printing properly?
I updated the encoding from Cp1252 before to UTF-8 and the NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are already set to unicode then restarted the sql developer but still same thing.
Make sure you're using an editor display font that supports Chinese characters, here's your test -
Oracle SQL Developer is a Java swing application, everything is Unicode by definition.
- Extracting valid timestamps in SQL
- MySQL union - alias not visible
- SQL count occurrences based on values in other columns
- Find values that are 6 characters long in a string, pipe delimited
- How to write this SQL query to find each account balance?
- SQL Query to get latest price
- Join newest price from price-table for all products
- Order By In a SQL Table Valued Function
- Return columns with a single value
- Missing FROM-clause entry for a table
- Convert JSON to table when all JSON field keys are unknown/arbitrary/random
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- SQL query to get the employee who has not been appraised
- TOAD for Oracle, variables for schema/ table names
- TSQL Pseudo Random text generator
- Get user last purchase date from specific product in WooCommerce
- Recursive CTE in Postgresql
- Add missing dates in a table
- ORACLE APEX ADMIN LOGIN ISSUE
- Cast value to type (TEXT) using string representation of type ("TEXT")
- Get records that have total count of over X amount
- Excluding records between dates AND with an associating value
- Turn cell values into columns in MySQL
- SQLdevelopersfruit puzzle
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- Fetch last row for each month, or previous month if not found
- Convert table with columns as path (bread crumbs / levels) to hierarchy (tree) representation
- How to create table like another table with additional columns in MYSQL
- Connecting to Microsoft SQL server using Python