in oracle, i can't insert into Chinese

happyls

Chinese becomes garbled after inserting records.
(It is the same whether you use the program or oracle client editing tool)
I am new to oracle, thanks for your help

whbilly

On what platform?

sanshuimei

Character set problem What character set is your client, does not support Chinese
What character set does the server support? Does not support Chinese? The two character sets are different

happyls

The server is on linux and the client is on windows. thank you

whbilly

If it's a windows platform

Execute in the database:
SELECT * FROM V $ NLS_PARAMETERS;


Change the value of NLS_LANG in the client registry ORACLE to the previously found NLS_LANGUAGE.NLS_CHARACTERSET

whbilly

That is to say, the character set of the server and the client must be the same, so that there will be no garbled characters

happyls

How do I see what character set Oracle uses on Linux, can I give the command line?

liub950511

First you need to determine what your Oracle character set is. If your Oracle character set does not support Chinese, it will be garbled when displayed later.
The solution in Java:
Transcode Chinese to ISO and save it, and then convert from ISO to GBK when displaying, there will be no problem.

The java method of transcoding is as follows:
public static String ISO2GB (String isoStr)
{
if (isoStr == null)
return null;

String gbStr = "";
try
{
gbStr = new String (isoStr.getBytes ("ISO_8859_1"), "GBK");
}
catch (Exception e)
{
System.out.println (e);
}
return gbStr;
}
    


public static String GB2ISO (String gbStr)
{
if (gbStr == null)
return null;

String isoStr = "";
try
{
isoStr = new String (gbStr.getBytes ("GBK"), "ISO_8859_1");
}
catch (Exception e)
{
System.out.println (e);
}
return isoStr;
}

happyls

I run SELECT * FROM V $ NLS_PARAMETERS; after that it shows:

NLS_LANGUAGE = SIMPLIFIED CHINESE
NLS_CHARACTERSET = WE8ISO8859P1
(I feel like these two are the emperors)
What should I do if I come down?

liub950511

If you want to display Chinese in the Oracle client, you need to set the character set of the Client to the character set of the Server (the character set of the database is not the character set of the system) or a subset of the character set of the Server. For details, refer to thewhbillysolution.