erlang odbc mysql参数_Erlang ODBC 处理中文

SQL> select * from v$nls_parameters;

+-----------------------------------------------------------------+-----------------------------------------------------------------+

| PARAMETER | VALUE |

+-----------------------------------------------------------------+-----------------------------------------------------------------+

| NLS_LANGUAGE | AMERICAN |

| NLS_TERRITORY | AMERICA |

| NLS_CURRENCY | $ |

| NLS_ISO_CURRENCY | AMERICA |

| NLS_NUMERIC_CHARACTERS | ., |

| NLS_CALENDAR | GREGORIAN |

| NLS_DATE_FORMAT | DD-MON-RR |

| NLS_DATE_LANGUAGE | AMERICAN |

| NLS_CHARACTERSET | AL32UTF8 |

| NLS_SORT | BINARY |

| NLS_TIME_FORMAT | HH.MI.SSXFF AM |

| NLS_TIMESTAMP_FORMAT | DD-MON-RR HH.MI.SSXFF AM |

| NLS_TIME_TZ_FORMAT | HH.MI.SSXFF AM TZR |

| NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH.MI.SSXFF AM TZR |

| NLS_DUAL_CURRENCY | $ |

| NLS_NCHAR_CHARACTERSET | AL16UTF16 |

| NLS_COMP | BINARY |

| NLS_LENGTH_SEMANTICS | BYTE |

| NLS_NCHAR_CONV_EXCP | FALSE |

+-----------------------------------------------------------------+-----------------------------------------------------------------+

测试的数据库表：

mysql：

CREATE TABLE `t1` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`f1` varchar(45) DEFAULT NULL

)；

oracle:

create t1( "ID" NUMBER NOT NULL ENABLE, "F1" VARCHAR2(45 CHAR));

注意：

VARCHAR2字段“F1”的units是CHAR，而且一定要是CHAR(默认为byte)，为什么呢？后面会说

１、连接数据库