UTSTARCOM D60模式切换: *20030811#
联通宽带:m156b00100163@gz.unicom/055000
Thursday, May 21, 2009
Thursday, April 23, 2009
ORACLE INSTANT CLIENT for LINUX
1. download instantclient from oracle website;
2. extract downloaded files to a directory. ex. /opt/oracle/
3. open .bash_profile add the following codes to the end
# ORACLE ENVIRONMENT SETTINGS.
ORACLE_HOME=/media/software/java/instantclient_11_1
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME
export ORACLE_HOME TNS_ADMIN NLS_LANG LD_LIBRARY_PATH
4. re-login.
2. extract downloaded files to a directory. ex. /opt/oracle/
3. open .bash_profile add the following codes to the end
# ORACLE ENVIRONMENT SETTINGS.
ORACLE_HOME=/media/software/java/instantclient_11_1
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME
export ORACLE_HOME TNS_ADMIN NLS_LANG LD_LIBRARY_PATH
4. re-login.
Tuesday, March 31, 2009
import data from ACCESS/EXCEL to SQLSERVER
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
ACCESS:
select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'd:\orgmst.mdb';'ADMIN';'','SELECT * FROM org_mst')
EXCEL:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
'Excel 8.0;hdr=yes;database=D:\orgmst.xls',ORG_MST$)
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
ACCESS:
select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'd:\orgmst.mdb';'ADMIN';'','SELECT * FROM org_mst')
EXCEL:
select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
'Excel 8.0;hdr=yes;database=D:\orgmst.xls',ORG_MST$)
Friday, March 13, 2009
java swing (eg: ORACLE SQL Developer)中汉字显示方块的解决办法
1, 在jre的 lib/fonts 目录创建一个 fallback目录
2, 将windows的字体文件复制到这个新建的目录下
2, 将windows的字体文件复制到这个新建的目录下
Tuesday, March 10, 2009
Friday, March 6, 2009
wine 下中文字体的关键设置
在E文LINUX, 加 WINE 环境下,运行需要使用中文的软件时,
需要将 LANG设置成zh_CN.UTF-8
例如运行 powerdesigner.
将:
env WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
改成:
env LANG=zh_CN.UTF-8 WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
中文问题就解决了
更改字体大小:
[System\\CurrentControlSet\\Hardware Profiles\\Current\\Software\\Fonts]
"LogPixels"=dword:00000070
需要将 LANG设置成zh_CN.UTF-8
例如运行 powerdesigner.
将:
env WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
改成:
env LANG=zh_CN.UTF-8 WINEPREFIX="/home/username/.wine" wine "C:\Program Files\Sybase\PowerDesigner 12\pdshell12.exe"
中文问题就解决了
更改字体大小:
[System\\CurrentControlSet\\Hardware Profiles\\Current\\Software\\Fonts]
"LogPixels"=dword:00000070
Thursday, March 5, 2009
Subscribe to:
Posts (Atom)