Changes between Version 23 and Version 24 of oid/WorkLog/08-10-15


Ignore:
Timestamp:
Oct 15, 2008, 5:03:52 PM (16 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • oid/WorkLog/08-10-15

    v23 v24  
    189189 * 為了讓後續 INSERT 進去的中文字元維持 UTF-8, 必須在一開始的 SQL 語法加進 "SET NAMES 'utf8';"
    190190{{{
     191jazz@oceandb:~$ head -n 2 maincase.sql
     192SET NAMES 'utf8';
     193INSERT INTO maincase VALUES (9744, 'SBES_OR1_236', '海研一號236航次沿測線 single beam EK500 38 kHz 水深資料', '', false, 1, '', '(119.53454000000001,21.88411)', '(120.40064,22.782060000000001)', true, true, 'NCOR', 'NCOR', 'NCOR', 'NCOR', 'http://www.ncor.ntu.edu.tw/ODBS/odbs_old/cruise/gif/OR1_236.gif', '1989-12-11 00:00:00', '1989-12-12 00:00:00', 1, true, '2005-10-12 14:18:28.929034', false);
    191194jazz@oceandb:~$ mysql ncor -u oceandb -p < maincase.sql
    192195}}}