sqlite3替换换行符号

需求： 将数据库中的markdown文本导出后换行符变成了“\n”,再导入到其他数据库时需要将\n转成数据库中的换行。 方法： 在sqlite中 换行符 为x’0a’ Sqlite 字段替换换行符 方法为：update table set title =replace(title, x'0a','')

解释： 其实，在sqlite中特殊的字符是ASCLL码，如果想替换回车字符改成13，可以如下写法：

UPDATE table_name SET field_name=REPLACE(field_name,char(13),'') UPDATE table_name SET field_name=REPLACE(field_name,x'13'，‘')

最后，附上 ASCII码表 0-127

二进制DecodeHex 缩写/字符解释000000000 00NUL(null) 空字符000000011 01SOH(start of headling) 标题开始000000102 02STX (start of text) 正文开始000000113 03ETX (end of text) 正文结束000001004 04EOT (end of transmission) 传输结束000001015 05ENQ (enquiry) 请求000001106 06ACK (acknowledge) 收到通知000001117 07BEL (bell) 响铃000010008 08BS (backspace) 退格000010019 09HT (horizontal tab) 水平制表符00001010100ALF (NL line feed, new line) 换行键00001011110BVT (vertical tab) 垂直制表符00001100120CFF (NP form feed, new page) 换页键00001101130DCR (carriage return) 回车键00001110140ESO (shift out) 不用切换00001111150FSI (shift in) 启用切换000100001610DLE (data link escape) 数据链路转义000100011711DC1 (device control 1) 设备控制1000100101812DC2 (device control 2) 设备控制2000100111913DC3 (device control 3) 设备控制3000101002014DC4 (device control 4) 设备控制4000101012115NAK (negative acknowledge) 拒绝接收000101102216SYN (synchronous idle) 同步空闲000101112317ETB (end of trans. block) 传输块结束000110002418CAN (cancel) 取消000110012519EM (end of medium) 介质中断00011010261ASUB (substitute) 替补00011011271BESC (escape) 溢出00011100281CFS (file separator) 文件分割符00011101291DGS (group separator) 分组符00011110301ERS (record separator) 记录分离符00011111311FUS (unit separator) 单元分隔符001000003220(space) 空格001000013321!001000103422"001000113523#001001003624$0010010137251001103826&001001113927’001010004028(001010014129)00101010422A*00101011432B+00101100442C,00101101452D-00101110462E.00101111472F/001100004830000110001493110011001050322001100115133300110100523440011010153355001101105436600110111553770011100056388001110015739900111010583A:00111011593B;00111100603C<00111101613D=00111110623E>00111111633F?010000006440@010000016541A010000106642B010000116743C010001006844D010001016945E010001107046F010001117147G010010007248H010010017349I01001010744AJ01001011754BK01001100764CL01001101774DM01001110784EN01001111794FO010100008050P010100018151Q010100108252R010100118353S010101008454T010101018555U010101108656V010101118757W010110008858X010110018959Y01011010905AZ01011011915B[01011100925C\01011101935D]01011110945E^01011111955F_011000009660`011000019761a011000109862b011000119963c0110010010064 d0110010110165 e0110011010266 f0110011110367 g0110100010468 h0110100110569 i011010101066A j011010111076B k011011001086C l011011011096D m011011101106E n011011111116F o0111000011270 p0111000111371 q0111001011472 r0111001111573 s0111010011674 t0111010111775 u0111011011876 v0111011111977 w0111100012078 x0111100112179 y011110101227A z011110111237B {011111001247C011111011257D }011111101267E ~011111111277F DEL (delete) 删除