Installation and setup of the Sybase charset character set

1, installing the character set

For example, installing 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 the cp936:

Open the Program \sybase\adaptive Server enterprise\interactive SQL tool, connect the Sybase database, execute SQL:

> select Name,id from Syscharsets

The ID of the 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, restart two times, the first reboot may fail, ignore him continue to restart

When connecting a Sybase database, it is important to ensure that the encoding specified by the connection string (charset=cp936) is consistent with the encoding of the database

This article is from the "small Hebebe Technology Space" blog, please be sure to keep this source http://babyhe.blog.51cto.com/1104064/1543932

Installation and setup of the Sybase charset character set