garbled problem.
Let me summarize the process of setting up the character set:
1, after the installation of Sybase, if you want to set the character set to CP936, you must first install the character set, because the Sybase default character set table does not have the character set, the installation steps are as follows: (here Sybase's installation path is c:\sybase
Sybase is a world-renowned database manufacturer, and its relational database products Sybase SQL Server has a large number of users in large and medium-sized enterprises in China. The author in the course of many years of use, summed up the Sybase database management and maintenance of some of the experience, now take out to share with you.
We know that
Directory
First, sybase12.5 for NT version in the Win2000 platform installation, the interface characters appear garbled problem
Second, Sybase after the network share or copy to the local hard disk, still can not install the problem
Third, after the installation of Sybase can not start the problem
Iv. Syabse deadlock When creating a device, both win and Unix exist
Five, oracle8.1.x version on the P4 m
there are many hidden troubles in the whole process electronic attempt, such as the specification and confirmation of tax declaration. Secondly, the goal of electronic tax collection and management is to achieve standardization, the standard of the collection of administrative process is the implementation of tax reform in China is an important goal. Its realization needs a perfect, strong management system support. In this system, the application of database is very important. The database sel
Directory
First, sybase12.5 for NT version in the Win2000 platform installation, the interface characters appear garbled problem
Second, Sybase after the network share or copy to the local hard disk, still can not install the problem
Third, after the installation of Sybase can not start the problem
Iv. Syabse deadlock When creating a device, both win and Unix exist
Five, oracle8.1.x version on the P4 ma
Tags: network database IP network Technology Model library guarantee systemWith the continuous development of network technology, more and more work has begun to be done by means of network. On this basis, the development speed of network database is increasing. In real life you can access the network data Model library is also very much, but now the most vulnerable to users like the product or Sybase database audit system. Although its development an
Directory
I. The sybase12.5 for NT Version is installed on the win2000 platform. garbled Chinese characters are displayed on the interface.
2. sybase cannot be installed after the network is shared or copied to the local hard disk
Iii. Unable to start after sybase is installed
4. A deadlock occurs when syabse creates a device. Both windows and unix exist.
V. Oracle 8.1.x cannot run on P4 machines.
Content
I
Sybase Chinese garbled because the default encoding set for ISO-1, in Sybase Central v4.3 Chinese display as garbled, the character set is changed to cp936 or cp850, Chinese garbled solution.
Character Set replacement method:
1. Open Sybase Central to connect to the database, open the syscharsets table of the master database, and check whether cp936 data exists
Directory
First, sybase12.5 for NT version in the Win2000 platform installation, the interface characters appear garbled problem
Second, Sybase after the network share or copy to the local hard disk, still can not install the problem
Third, after the installation of Sybase can not start the problem
Iv. Syabse deadlock When creating a device, both win and Unix exist
Five, oracle8.1.x version on the P4 m
The Sybase replication server (Sybase Replication server) is designed to meet the needs of an increasingly evolving Enterprise Client/server computer environment. Since the replication server has been widely used, it has become the foundation of enterprise-wide client/server application model.
How Replication Servers work
The diagram of the Sybase Replication S
1. Log on to Windows NT as an administrator.
You need Administrator privileges to create, start, and stop services.
2. Open the command prompt.
3. Use the Dbsvc utility to create a service with the following restrictions:
You must use the-a switch to specify the Sybase account and use the-p switch to specify its password.
You cannot use the-as or-i switch.
For a personal database server, the name of the executable file should be:
C:\Program Fil
In Sybase databases, user management is an important part of system management, but its importance is often overlooked. Many times, the operation of the database command is often not successful with user management, and many of the occurrence of misoperation can also be avoided by user management. Therefore, to clarify some basic concepts of user management, the successful management of the database system has an important role. Below we will explain
How should the Sybase Master log be cleared when it is full?
You can manage the master library in the following ways, and if you do not have enough space, consider expanding the master library.
1, simple case of the dump trans with no_log on it, Master Library will not be full.
1> Use Master
2> Go
1> checkpoint
2> Go
1> dump Tran Master with NO_LOG
2> Go
00:00000:00011:2006/02/22 14:53:38.06 Server WARNING: *************************
**
00:0
1. The composition of Sybase software
Sybase software can be divided into three parts:
One is to conduct data management and maintenance of the online relational database management system Sybase SQL Server;
The second is to support the establishment of database application system and the development of a group of front-end tools software
1: Requirements: Install Sybase client software and SQL Server Software on PC
(I am installing the Sybase ASE 12.5.1 client software and SQL Server 2008 software on my Test PC.) )
2. Configure the ODBC data source for Windows:
Start menu-Control Panel (c)-Administrative Tools-Data source (ODBC)-"Enter the configuration User DSN or System DSN can: Add-" Select
When we use the sybase database, we often use excel to read the content in excel and insert it into the sybase Database Table. During this process, ex
When we use the sybase database, we often use excel to read the content in excel and insert it into the sybase Database Table. During this process, ex
Abstract: when
I don't know how many people use Sybase for database development. With Sybase ase ado. net, the system is running normally after a lot of resistance is broken through. Further efforts should be made to increase data permissions. We used to judge using the result set directly returned by the function on SQL Server. However, Sybase does not support functions, so we
Use commands to operate sybase databases
This article consists of four parts: Starting and disabling databases by using commands, creating databases, backing up databases, and exporting database structures.(1) Start and close the database Sup2; UNIX platform:Log On As a Sybase installation account or as a root user, and run the following command to enter the Sybase
Q: After the Sybase Database runs for a period of time, the system runs slowly?
ISQL can be used to log on to the ASE for execution.
Select @ version
Go
View the database version.
If you are using ase12.0, we recommend that you use ase12.5 or above, because since Sybase has been overtaken by Oracle in the database market, Sybase has launched new products very q
For information about how to set the sybase Chinese Character Set, most of the information found on the internet is set with commands in the isql environment. The procedure is as follows:
(The installation path of SYBASE is c: sybase)
How to install the cp936 Character Set
3. In the ISQL Environment
1> select name, id from syscharsets
2> go
Find the id correspond
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.