Sybase Database garbled

2010-07-21  来源:本站原创  分类:Database  人气:172 

Question: Sybase v12 backup file into Sybase v15, the character display reasons: the database character set is not the same, v12 and v15 is the CP850 is the CP936
Solution: the v15 of the character set to CP936
1, the installation CP936 character set: $ Sybase_Home/charsets/cp936> charset cp936.bin
2, modify the database in Sybase Central properties in default character set id entry 171, the value can be found in the system table syscharsets.
3, restart the database, so changes to take effect, both the new library, restore.

相关文章
  • sybase database garbled text problem 2010-03-11

    1.Sybase database log full When this situation occurs often can query data, but can not update the data, start affairs. Tracking can be found in the code, the connection can be opened, but the transaction is not open. Often prompt "Connection to Syba

  • Sybase Database garbled 2010-07-21

    Question: Sybase v12 backup file into Sybase v15, the character display reasons: the database character set is not the same, v12 and v15 is the CP850 is the CP936 Solution: the v15 of the character set to CP936 1, the installation CP936 character set

  • Sybase Chinese garbled solution 2011-07-19

    Sybase Chinese garbled due to the default encoding set to ISO-1, in the Sybase Central v4.3 is garbled in Chinese, will change the CP936 or CP850 character set, the Chinese garbled solution. Replacement character set method: First, open the Sybase Ce

  • bcp sybase database backup tool 2010-02-10

    ============= [October 24, 2007] PM ============================ === Dinner at noon today on the way to casually ask how to export data Xiaoming sybase, bcp can say so little, and then a look at google found bcp, looked for a moment its parameter lis

  • Sum up the work in the Sybase database (1) 2010-04-08

    1.BCP command BCP is a SYBASE database table provides a dedicated data backup tool. Generally stored in the installation of ASE or Open Client's BIN directory. 12 version of the previous ASE, bcp store directory is $ SYBASE / bin 12 version (with 12

  • Sum up the work in the Sybase database (2) 2010-04-08

    Sybase database using the command mode operation This article includes command mode startup and shutdown database, create database, backup database and export the database structure of four parts. (A) startup and shutdown database ² UNIX platforms: S

  • Sum up the work in the Sybase database (3) 2010-04-08

    Simple operation command sybase database 1, the backup database dump database database_name to dump_device Description: database_name is the name of the database to be unloaded, dump_device name of the device is unloaded. With the system process sp_h

  • Sum up the work in the Sybase database (6) 2010-04-08

    Some exceptions and on the common approach 1. The following statement is used to handle the log full of Sybase data when (The transaction log in database EBILLS is almost full. Your transaction is being suspended until space is made available in the

  • sybase database configuration experience exchange 2010-06-25

    Sybase configuration parameters sp_configure 'max online engines', 4 go - Configure the number of boot cpu sp_configure 'number of engines at startup', 4 go - Configure the maximum memory number sp_configure 'max memory', 2097151 go - The largest all

  • Sybase database on the link to install DBArtisan, the report documents the lack of libct.dll and libcs.dll 2010-12-20

    http://blog.csdn.net/sdytgl/archive/2008/10/16/3085363.aspx http://liss.javaeye.com/admin/blogs/847455 A, QQ always dropped some time ago has been CCTV watching the Olympics live online, but while watching it live on the inexplicable QQ always droppe

  • Sybase database, the problem of fuzzy query 2011-01-07

    Today came across a very strange question, Sybase database fuzzy query (like), the query results may be wrong. For example: select Name from TestTable where Name like '% Oh %' Check out the results will not include the name of "Oh," the data. An

  • DBArtisan link sybase database installed, the report documents the lack of libct.dll and libcs.dll 2010-12-20

    http://blog.csdn.net/sdytgl/archive/2008/10/16/3085363.aspx http://liss.iteye.com/admin/blogs/847455 A, QQ always dropped some time ago has been watching the Olympics live online in CCTV, but watching it live, while QQ is always somehow dropped. Susp

  • Sybase database query problem fuzzy 2011-01-07

    Today came across a very strange question, Sybase database for fuzzy queries (like), the results may be wrong. For example: select Name from TestTable where Name like '% Oh %' Check out the results will not include the name of "Oh," the data. An

  • Sybase Database issue summary 2011-01-26

    Today, the project data into DB2 database from Sybase database, install the Sybase15. And to test whether the normal operation of the project; Encountered a few problems: 1, create the table: 1) sybase data, but case-sensitive, including the table na

  • Sybase Database maintenance 2011-02-21

    Sybase Database maintenance maintenance purposes: The current operational status monitoring database, to ensure stable operation of the database. Do the daily backup of the database work, to reduce the risk of problems and responsibilities when Detec

  • The full amount of the Sybase database backup program 2011-03-04

    Sybase database products since its inception in 1987, its client / server (client / server) mode, the foundation distributed processing architecture, improved security performance, high-speed and efficient operation mode, multi-platform operating sys

  • sybase database using a laptop 2011-08-10

    A recent project using sybase database. . . An egg is called pain. . . Out of the injury. . . First garbage problem: This is a platitude. Internet connection string that followed a charset = cp850 on the line. . I tried the next not. . . And then say

  • Sum up the work in the Sybase database (5) 2010-04-08

    This is the last year has been a difficult problem, focus on server and client character set themselves the problem of inconsistent After installing Sybase, many people use the isql or program data into the Chinese found, query the data is garbled (C

  • (Turn) into mysql database, garbled, solutions? 2010-03-26

    Chinese characters in the mysql database containing documents from the command line into mysql database, easy garbled, This article describes the sql file into mysql database, not garbled a solution: 1, open the sql file, the first line in the SQL fi

  • Read the value inside the database garbled 2010-04-02

    eeclipse where the Chinese are garbled, including the notes, but the information inside the database can be displayed in Chinese, which reads the value from the database when the garbled, need to change two places: 1. Eeclipse inside, open the Proper