I am trying to select just the value from a table on SQL Anywhere 12.0.1 and keep getting strange characters in the first columns of the output file: Example command: dbisql @dbadmin_dbn -nogui "unload select VolumeName from backupvols where BackupScheduleID = ${BKPSET} to '${MASTERLOG}' FORMAT ascii delimited by ' '" Example output: $ cat /tmp/nvitpcmnf550_11_25_2013_13.04.16_log 'eac_dv_sybsft1_01' 'eac_dv_sybbkp_01' How do I get rid of these odd characters ? asked 25 Nov '13, 14:08 JoStick Graeme Perrow |
From: http://en.wikipedia.org/wiki/Byte_order_mark (BOM)
Meaning that your source data is UTF-8, and are displaying it currently using CP1252. From: http://dcx.sybase.com/index.html#sa160/en/dbreference/unload-statement.html
So, use
Your database character encoding is UTF-8, so the default is answered 25 Nov '13, 15:37 Jeff Albion |