Categories
DATABASE Programming/php System/Linux/Unix*

[memo] Oracle : 把資料用 UTF8 編碼存進 table / NLS_LANG / NCHAR / NVARCHAR / NLS_CHARACTERSET / NLS_NCHAR_CHARACTERSET / SQL plus

UTF8 sample:

螢幕快照 2014-10-28 下午9.21.47

URL : http://www.unicode.org/cgi-bin/GetUnihanData.pl?codepoint=竝

螢幕快照 2014-10-28 下午9.28.02

Oracle : 把資料用16進位印出來 dump(field,16)
螢幕快照 2014-10-28 下午8.30.11

螢幕快照 2014-10-28 下午8.35.36

 

用 locale -a 看 系統支援的 locales

參考 : Oracle® Database Globalization Support Guide : http://docs.oracle.com/cd/E11882_01/server.112/e10729/toc.htm

Categories
DATABASE Network service

Amazon AWS RDS service / create / launch DB instance / screenshot

Categories
DATABASE

[memo] Oracle : select * from v$nls_parameters

Categories
System/Linux/Unix*

solr , choice / install / misc

Categories
System/Linux/Unix*

增加 1G swap file , mkswap

sudo /bin/dd if=/dev/zero of=/swap.1 bs=1M count=1024
sudo /sbin/mkswap /swap.1
sudo /sbin/swapon /swap.1

Categories
Programming/javascript Programming/misc

Google Analytics : 自定特殊統計 tag sample

https://developers.google.com/analytics/devguides/collection/analyticsjs/events

 

<script>
…….
ga(‘create’, ‘UA-xxxxxxxx-1’, ‘xxxx.com’);
ga(‘send’, ‘pageview’);
ga(‘send’, ‘event’, ‘分類瀏覽數’, ‘xxx’);
ga(‘send’, ‘event’, ‘分類瀏覽數’, ‘yyy’);
ga(‘send’, ‘event’, ‘小計瀏覽數’, ‘zzz’);
</script>