Sybase ASE数据库的图形界面安装，虽然比较顺利，但是也让中文用户很不爽，那就是字符集的选择，似乎没有余地，只能Customize选择，还不一定一次能选对。
比如，你一路安装的时候, ASE sql server创建的时候，很难从界面里头选择语言和字符集。
还好，ASE15.x提供了silent install的方式。
1. 安装并生成silent install的配置文件
运行setupconsole.exe -options-record c:\ase1503_silentinstall.txt，这一路你只安装软件，可选择完全安装，但别装数据库服务。
这样得到了样本配置文件：ase1503_silentinstall.txt
注意一边这几项内容即可：
-P installLocation="D:\sybase" ## 你可以到时候改为你想要的目录
-W installSoftwareLicenseType.type=developer
-W sysamLicense.proceedWithoutLicense=false
-W sysamLicense.useExistingLicenseServer=false
-W sysamLicense.licenseFile=
-W askConfig.configureAse=false
-W askConfig.configureBackup=false
-W askConfig.configureMonitor=false
-W askConfig.configureXp=false
-W askConfig.configureJobScheduler=false
-W askConfig.configureSelfManagement=false
-W askConfig.configureUnifiedAgent=false
这样安装完，你会得到一套没有数据库服务的Sybase ASE15.x. 如果你将其卸载，接着，运行：
setupConsole.exe -silent -options c:\ase1503_silentinstall.txt -W SybaseLicense.agreeToLicense=true -G replaceExistingResponse="yesToALL"
即可实现silentinstall。
2. build ase server
限于篇幅，这里以ASE的主server: sybase sqlserver为例，进入目录：
%SYBASE%\%SYBASE_ASE%\bin, 有个命令sybatch.exe，这个命令长期不见之于文档，不知道什么原因，它就是windows版的sqlbuilder，用于创建各个服务的。
输入资源配置文件在哪儿呢？从%SYBASE%\%SYBASE_ASE%\samples\server里头把sybatch_ase.res文件复制到c:\sybatch_ase.res
修改一下里边的内容，不然，肯定大多会失败：
改的地方：
1). 安装目录，保持一致
sybinit.boot_directory: D:\Sybase
sybinit.release_directory: D:\Sybase
所有的C:\**什么的，都得调成你现在安装的位置，包括数据文件。
2) sysprocs.dat文件大小，132太小，改成至少136
sqlsrv.do_create_sybsystemprocs_device: yes
sqlsrv.sybsystemprocs_device_physical_name: D:\Sybase\data\sysprocs.dat
sqlsrv.sybsystemprocs_device_size: 150
sqlsrv.sybsystemprocs_db_size: 150
sqlsrv.sybsystemprocs_device_logical_name: sysprocsdev
3) 字符集，这个是大家比较关心的：
sqlsrv.sort_order: binary
sqlsrv.default_characterset: utf8
sqlsrv.default_language: us_english
默认的是iso_1, english
4)下边三个值你可以改成你想要的
sqlsrv.server_name: SYBASE
sqlsrv.sa_password:
sqlsrv.sa_login: sa
这里帖出一个由sybatch.exe创建Sybase SqlServer服务的结果：运行sybatch.exe -r c:\sybatch_ase.res
结果如下：
D:\sybase\ASE-15_0\bin>sybatch.exe -r d:\SOFT\sybatch_ase.res
CONNECTIVITY ERROR: Open Client message: 'ct_connect(): network packet layer: in
ternal net library error: Net-Lib protocol driver call to connect two endpoints
failed
Failed to connect to the server - Error is 10061 由于目标机器积极拒绝，无法连接
。
'.
CONNECTIVITY ERROR: Initialization of auditinit connectivity module failed.
Running task: update Sybase Server entry in interfaces file.
Task succeeded: update Sybase Server entry in interfaces file.
Running task: create the master device.
Building the master device
......Done
Task succeeded: create the master device.
Running task: update Sybase Server entry in registry.
Task succeeded: update Sybase Server entry in registry.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Running task: create the sybsystemprocs database.
sybsystemprocs database created.
Task succeeded: create the sybsystemprocs database.
Running task: install system stored procedures.
Installing system stored procedures : 10% complete...
Installing system stored procedures : 20% complete...
Installing system stored procedures : 30% complete...
Installing system stored procedures : 40% complete...
Installing system stored procedures : 50% complete...
Installing system stored procedures : 60% complete...
Installing system stored procedures : 70% complete...
Installing system stored procedures : 80% complete...
Installing system stored procedures : 90% complete...
Installing system stored procedures : 100% complete...
Task succeeded: install system stored procedures.
Running task: set permissions for the 'model' database.
Task succeeded: set permissions for the 'model' database.
Running task: set local Adaptive Server name.
Task succeeded: set local Adaptive Server name.
Running task: set the XP Server for the Adaptive Server.
Task succeeded: set the XP Server for the Adaptive Server.
Running task: update XP Server entry in registry.
Task succeeded: update XP Server entry in registry.
Running task: create temporary database.
Task succeeded: create temporary database.
Running task: set the default character set and/or default sort order for the Ad
aptive Server.
Setting the default character set to utf8
Installing character set 'utf8'
.Done
Sort order 'binary' has been successfully installed.
Sort order 'binary' has been successfully set to the default.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: set the default character set and/or default sort order for the
Adaptive Server.
Running task: set the default language.
Setting the default language to us_english
Language 'us_english' is already the default.
Task succeeded: set the default language.
Running task: install sybsystemdb database.
sybsystemdb database extended.
Task succeeded: install sybsystemdb database.
Running task: set the Backup Server for the Adaptive Server.
Task succeeded: set the Backup Server for the Adaptive Server.
Running task: shutdown the Sybase Server.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
Task succeeded: shutdown the Sybase Server.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Configuration completed successfully.
Running task: optimize ASE.
Optimize Configuration procedures : 10% complete...
Optimize Configuration procedures : 20% complete...
Optimize Configuration procedures : 30% complete...
Optimize Configuration procedures : 40% complete...
Optimize Configuration procedures : 50% complete...
Optimize Configuration procedures : 60% complete...
Optimize Configuration procedures : 70% complete...
Optimize Configuration procedures : 80% complete...
Optimize Configuration procedures : 90% complete...
Optimize Configuration procedures : 100% complete...
Task succeeded: optimize ASE.
Running task: shutdown the Sybase Server.
Waiting 15 seconds for the operating system to reclaim resources before rebootin
g.
Task succeeded: shutdown the Sybase Server.
Running task: start the Sybase Server.
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
waiting for server 'SYBASE' to boot...
Task succeeded: start the Sybase Server.
Configuration completed successfully.
Exiting.
The log file for this session is 'D:\sybase\ASE-15_0\init\logs\log0418.003'.
#
# --- This is a "sybatch.exe" sample resource file. ---
#
# This sample resource file will configure a new
# 2k pagesize Adaptive Server "SYBASE".
#
sybinit.boot_directory: D:\Sybase
sybinit.release_directory: D:\Sybase
sqlsrv.do_add_server: yes
sqlsrv.network_hostname_list: sql9xp
sqlsrv.network_port_list: 5000
sqlsrv.network_protocol_list: tcp
sqlsrv.notes:
sqlsrv.connect_retry_delay_time: 5
sqlsrv.connect_retry_count: 5
sqlsrv.new_config: yes
#
sqlsrv.server_name: SYBASE
sqlsrv.sa_password:
sqlsrv.sa_login: sa
sqlsrv.server_page_size: 2k
#
# --- Set up master ----
#
sqlsrv.master_device_physical_name: D:\Sybase\data\master.dat
sqlsrv.master_device_size: 200
sqlsrv.master_db_size: 13
sqlsrv.disk_mirror_name:
#
# --- Set up sybsystemprocs ----
#
sqlsrv.do_create_sybsystemprocs_device: yes
sqlsrv.sybsystemprocs_device_physical_name: D:\Sybase\data\sysprocs.dat
sqlsrv.sybsystemprocs_device_size: 150
sqlsrv.sybsystemprocs_db_size: 150
sqlsrv.sybsystemprocs_device_logical_name: sysprocsdev
#
# --- Set up sybsystemdb ----
#
sqlsrv.do_create_sybsystemdb: yes
sqlsrv.do_create_sybsystemdb_db_device: yes
sqlsrv.sybsystemdb_db_device_physical_name: D:\Sybase\data\sybsysdb.dat
sqlsrv.sybsystemdb_db_device_physical_size: 50
sqlsrv.sybsystemdb_db_size: 50
sqlsrv.sybsystemdb_db_device_logical_name: systemdbdev
#
sqlsrv.errorlog: D:\Sybase\ASE-15_0\install\sybase.log
sqlsrv.sort_order: binary
sqlsrv.default_characterset: utf8
sqlsrv.default_language: us_english
#chinese
sqlsrv.preupgrade_succeeded: no
sqlsrv.network_name_alias_list:
sqlsrv.resword_conflict: 0
sqlsrv.resword_done: no
sqlsrv.do_upgrade: no
sqlsrv.characterset_install_list:
sqlsrv.characterset_remove_list:
sqlsrv.language_install_list:
sqlsrv.language_remove_list:
sqlsrv.shared_memory_directory:
sqlsrv.addl_cmdline_parameters:
sqlsrv.eventlog: yes
sqlsrv.atr_name_shutdown_required: yes
sqlsrv.atr_name_qinstall: no
#
sybinit.charset: utf8
sybinit.language: us_english
sybinit.resource_file:
sybinit.log_file:
sybinit.product: sqlsrv
#
sqlsrv.default_backup_server: SYBASE_BS
#
# optimize ASE
#
sqlsrv.do_optimize_config: yes
sqlsrv.avail_physical_memory: 300
sqlsrv.avail_cpu_num: 1
sqlsrv.tempdb_device_physical_name: D:\Sybase\data\tempdb.dat
sqlsrv.tempdb_device_size: 100
sqlsrv.tempdb_database_size: 100
sqlsrv.application_type: MIXED
文章浏览阅读4.7k次。ehcache介绍Ehcache是一个纯Java的进程内缓存框架，具有快速、精干等特点，是Hibernate中默认的CacheProvider(hibernate-ehcache )。当然也可以和mybatis(mybatis-ehcache)结合,它具有内存和磁盘存储,ehcache直接在jvm虚拟机中缓存，速度快，效率高；但是缓存共享麻烦，集群分布式应用不方便,如果大规模集群还是考虑用memc...
文章浏览阅读1.2k次，点赞4次，收藏25次。前端高频55道面试题汇总，包含css，js，vue等等，自己总结，如有错误或者不足的地方欢迎指正，喜欢的话谢谢给个三连，阿里卡多！！！_get post put delete面试题
文章浏览阅读9.8k次，点赞6次，收藏12次。转载自：https://www.ripjava.com/article/1294911926173728叙述在这篇快速的文章中，我们将探讨Java中计算两个日期之间差值的一些方法。解决方案使用 java.util.Date让我们首先使用Java SE API计算两个日期之间的天数：@Testpublic void test_TwoDatesDiffBeforeJava8() throws ParseException { SimpleDateFormat sdf = n_chronounit.seconds.between
文章浏览阅读3.5k次。git checkout 报错原因在一个空的目录中（/item）执行命令git init成功创建一个空的git仓库执行：git checkout -b dev成功创建一个dev分支现在想checkout到master分支执行：git checkout mster不好意思，突然报错了，是什么原因呢？错误信_$ git checkout -- zyq4.txt error: pathspec 'zyq4.txt' did not match any file
文章浏览阅读163次。通过配置/application/config/config.php文件的$config['url_suffix']值，可以为CodeIgniter生成的URL添加一个指定的文件后缀，注意不要漏了点 $config['url_suffix'] = '.html';比如这个URL：example.com/index.php/products/view/shoes，如果配置后缀为html，那么跳转..._codeigniter 路由后缀
文章浏览阅读646次。预留度数Rx表达式的推导1. sympy简介2. Holliday12.1 P的计算源码2.2 Rx表达式的推导3 HofferQ3.1 P的计算源码3.2 Rx表达式的推导1. sympy简介 sympy是Python中强大的符号运算包，可用于多种计算，如微积分运算、解方程、矩阵运算等 人工晶状体度数的计算代码参考R程序包enbrown/iol-calculations 1 安装该包的方法install.packages("devtools")library(devtools)inst_holladay 1公式怎么书写
文章浏览阅读2.2k次，点赞3次，收藏7次。通过编写爬虫程序，实现对空气质量指数网站上指定地区和时间段内的AQI进行获取，并实现数据可视化实验步骤：安装pyspider在anaconda prompt中使用命令行安装：若提示升级，则根据提示进行下载PhantomJS,并配置环境变量可在如下网址中进行下载https://phantomjs.org/download.html5.用命令行启动pyspider..._气道管理可视化设备可采集哪些数据
文章浏览阅读9.1k次。本文主要内容：一、 讲稿全文1. 序言与分工2. 工程师的伦理规范定义2.1 工程伦理的解释2.2 工程伦理规范3. 工程师的伦理问题分析3.1 工程设计伦理问题3.2 工程安全伦理问题3.3 工程揭发伦理问题4. 工程师的伦理规范分析4.1 工程师的权利和责任4.2 应对职业行为中的伦理冲突4.3 工程师的伦理规范5. 总结与展望5.1 总结5.2 展望二、 PPT演示三、 文档下载
文章浏览阅读6k次。刚在centos 7上安装Nacos 时启动，发现报错了，看了报错信息，是启动内存不够，我们打开启动脚本查看了一下standalone代表着单机模式运行，非集群模式Xms 是指设定程序启动时占用内存大小Xmx 是指设定程序运行期间最大可占用的内存大小-Xmn 新生代的大小我们调整下 Xms 和 Xmx 的大小 ,进入 nacos bin目录下，执行sh startup.sh -m standalone访问 ip:8848/nacos 用户名 密码都是 na..._centos nacos 修改内存
文章浏览阅读134次。好吧，我承认您看了题目以后，可能就会很嫌弃的说，不就是一个博客吗，谁不会搞啊，某浪，某讯都有博客，注册一个博客谁还不会，用得着你教我嘛。您先静一静，喝口水压压惊，我们这里是帮您拥有一个属于您自己的不会冠以某浪某讯的title并且拥有更多freestyle的博客界面的博客，有点小心动的话，就去动手做一个吧。我和大家一起搭建博客平台，并发现一些小的技巧来丰富..._云计算搭建个人博客
文章浏览阅读961次。通过snd_soc_register_card来注册card，即注册整个machine driver.此函数接收一个参数 snd_soc_card：/* SoC card */struct snd_soc_card { const char *name; const char *long_name; const char *driver_name; ..._snd_soc_register_card
文章浏览阅读258次。MQ选型对比RabbitMQ RocketMQ ActiveMQ Kafka（外加redis对比及其实现）rocketmq 4.3开始支持事务https://www.cnblogs.com/hzmark/p/rocket_txn.html参考：rabbitMQ、activeMQ、zeroMQ、Kafka、Redis 比较redis vs rabbitmq可靠消费Redis：没有相应的机制保证消息的消费，当消费者消费失败的时候，消息体丢失，需要手动处理RabbitMQ：具有消息消费确认，即使_rabbitmq rocketmq kafka redis