Oracle NLS-Lang Settings
13-Aug-10To use SQL*Plus Windows correctly, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 If you prefer the command line client SQL*Plus, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8PC850
Using SQL*Plus without tnsnames.ora
29-Mar-10As often, a quick reminder for me. I’m using the Oracle Instaclient on my Mac without a tnsnames.ora and i keep forgetting the connectstring syntax: sqlplus USER/PASS@//HOST:PORT/SIDsqlplus USER/PASS@//HOST:PORT/SID Extra bonus points: Through in rlwrap to get a nice commandline history and completion as used to in a standard shell: rlwrap sqlplus USER/PASS@//HOST:PORT/SIDrlwrap sqlplus USER/PASS@//HOST:PORT/SID
SVN: Revert to previous version
09-Sep-09Just a quick reminder: To revert a complete working copy or a single file use: svn merge -rHEAD:PREV . # or svn merge -rHEAD:PREV path/to/file svn commit -m "reverted"svn merge -rHEAD:PREV . # or svn merge -rHEAD:PREV path/to/file svn commit -m "reverted"
Batchconvert ascii to utf8
12-May-09Next time i see umlauts in source, I’ll scream. Loud. In the mean time I try this: find . -iname "*.java" -exec sh -c ‘iconv -f cp1252 -t utf-8 {} > {}.utf8’ \; for i in `(find . -name "*.utf8")`; do mv $i ${i/.utf8/}; donefind . -iname "*.java" -exec sh -c ‘iconv -f cp1252 -t […]
XML / XSD Schema validation on Mac OS X
16-Jan-09I found no fancy graphical xml validator on OS X, but this isn’t a problem. OS X includes libxml which comes with xmllint. To validate a xml file against a schema: xmllint –noout –schema sitemap.xsd sitemap.xmlxmllint –noout –schema sitemap.xsd sitemap.xml