Shulou(Shulou.com)06/01 Report--

1, install the character set

For example, install cp036:

1) install cp936

> cd c:\\ sybase\ charsets\ cp936

C:\ Sybase\ charsets\ cp936 > charset-Usa-Ppassword-Sserver binary.srt cp936

2) query the character set ID of cp936:

Open the program\ sybase\ adaptive server enterprise\ interactive SQL tool, connect to the sybase database, and execute sql:

> select name,id from syscharsets

The ID of cp936 is 171,

3) execute the following command in the interactive SQL tool, and set the default encoding to cp936:

> sp_configure "default character set id", 171

4) find the sybase service in the service and restart it twice. The first restart may fail. Ignore it and continue to restart.

When connecting to a sybase database, make sure that the encoding specified by the connection string (charset=cp936) is consistent with that of the database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.