Sybase cannot display solutions to Chinese problems

Sybase adaptive server enterprise 1500 FOR WINDOWS

Prerequisites: windows classic theme. If you have installed sybase incorrectly before, uninstall the sybase folder and related registry keys !)

Run setup.exe for installation. If you need to use ODBC, OleDb, or ADO.net for development, You must select custom m for installation. Because by default, only the JDBC driver is installed, other drivers are not installed. After installation, you can go to "Control Panel"> "performance and maintenance"> "Data Source (ODBC)" of "Administrative Tools.

After restarting as instructed, go to control page> Management Tools> services, find the sybase SQLserver _ server name, and start the service. Then you can perform the operation.

For settings that cannot be properly displayed in Chinese, perform solution 1 first. If not, go to solution 2)

Solution 1)

Choose Start> All Programs> Sybase> Adaptive Server Enterprise> Server Config to open the Configure Sybase Server window. Select Adaptive in the Product column on the left of the window, and click "Configure Adaptive Server..." to open the "Existing Servers" window. Select the server in the window, and click "Continue" to enter the next window. Enter the user name and password. The default user name is sa, and the password is blank. Click "Continue. If the service is not enabled, Sybase will prompt and click "OK". Wait a moment and the "Configure Adaptive Server" window will appear.

Click "Language" in the window to open the "Language Options" window.

Click "Add/Remove" under Character to open the "Install Character Sets" window, select "Unicode 3.1 UTF-8 CHaracter Set" in the Available column, that is, utf8 Character Set, click "Add" and click "OK. Next, click the "Set Default" button under Character to open the "Change Default Character Set" window. The "Code Page 850 (Multilingual) character set" is selected by Default, that is, the cp850 Character Set. This character set is incorrect. Select the newly added utf8 Character Set, click OK, return to the "Language Options" window, and then click OK. As we re-set the service, we need to wait for a while.

After setting, open the "run" window, enter the command "services. msc/s", and open "service ". Select "Sybase SQLServer _ IMAGE". "IMAGE" is my Sybase service name. Click "Start service". After a moment, the system prompts that the startup failed and restarts the operating system. After the restart, start Sybase again in the "service". If an error is still prompted, don't worry about it. It's okay to start the service again.

After the service is started, click "start"> "All Programs"> "Sybase"> "Sybase Central v4.3" to open Sybase Central, a Sybase client tool. Open Adaptive Server Enterprise in the left-side Folders, select Default, right-click it, and select Connect... to open the Connect window.

In the window, set User ID to sa, Password to null, Server name to IMAGE, Character set and Language to cp936 and Chinese, respectively. Note that the character set on the client is cp936, not cp850, utf8, or eucgb. After setting, click OK to start Sybase operations.

Solution 2)

Open a command prompt and perform command operations. (The installation path of SYBASE is c: \ sybase)

 
 

  
  
1. c :\>; cd d: \ sybase \ charsets \ cp936
  
  
2. c: \ sybase \ charsets \ cp936> charset-Usa-Psa_pass can be empty)-Sserver_name (Service name)
  
  
Binary. srt cp936 (charset-Usa-P-SBUPTCSLUXQ binary. srt cp936)
 
 

3. In the SQL Environment

 
 

  
  
1>;select name,id from syscharsets   
  
  
2>;go  
 
 

Find the id corresponding to name cp936 (assuming 171)
4.

 
 

  
  
1>;sp_configure "default character set id",171   
  
  
2>;go 
 
 

5. Restart the server service twice. Note: after the first restart, the server will automatically go down and need to be restarted for use)

After that, you can use it normally, archive it yourself, and share it with everyone.