ITPub博客

搞懂oracle字符集作为一个ORACLE DBA,在工作中会经常处理由于字符集产生的一些问题。但是当真正想写一些这方面的东西时，却突然又没有了头绪。发了半天呆，还是决定用两个字符集方面的例子作为切入点，倒不失为一个头绪，说不定在实验的过程中，问题就会一个接着一个的浮现出来。现在，让我们切入正题。我用的数据库是oracle10.2.0.3,数据库字符集是al32utf8。客户端就是同一台机器的windows xp.下面是演示的例子：SQL> drop table test purge;Table dropped.SQL> create table test(col1 number(1),col2 varchar2(10));Table creat

export: mysqldump database [table] > /tmp/filenameimport: mysql database < /tmp/filenamecan add "max_allowed_packet=104857600" under [mysqld] in /etc/my.cnf file to resolve the "Got a packet bigger than 'max_allowed_packet' bytes" problem.There is some problems with this import method.If the mysqldump version is low, the triggers and procedure can not be export. You can upgrade the mysqldump or use remote new version mysqldump to export.trigger is default, procedure nee

When there is no name-resolve, the mysql connection will be slow.Add 'skip-name-resolve' under '[mysqld]' section in /etc/my.cnf will resolve this problem.[@more@]

Oracle escape string only valid to "_", "%" and itself.For example, use "" as escape string,like 'abc%' escape '', will encounter oracle ORA-01424 errorSo when support the escape string, must take care.Should Transfer the single '' with other string.[@more@]