oracle xe thai 8 bit

sqlplus / as sysdba

CREATE USER xxx IDENTIFIED BY pppp DEFAULT TABLESPACE users;
GRANT CONNECT, RESOURCE TO xxx;
GRANT privilege TO xxx;

GRANT DBA TO xxx;


SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE TH8TISASCII;
SHUTDOWN;
STARTUP;

ทำ reverse
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SHUTDOWN;
STARTUP;


http://www.narisa.com/forums/index.php?showtopic=13641

birt xml datasource ref Project Path in Eclipse

script : beforeOpen Data Source

xml = params['xml'];
java.lang.System.out.println(xml);
file = org.eclipse.core.resources.ResourcesPlugin.getWorkspace().getRoot().getProject("PROJECT").getFolder("XML_PATH").getFile(xml).getLocation();
this.setExtensionProperty("FILELIST", file);

php ต่อ ingres

http://en.kioskea.net/faq/923-connecting-to-an-ingres-database-with-php
http://www.php.net/manual/en/function.ingres-connect.php

$objConnect = ingres_connect("demodb","ingres","password");
if($objConnect)
{
echo "Database Connected.";
}
else
{
echo "Database Connect Failed.";
}

mssql_close($objConnect);

เปลี่ยน password root ของ mysql ubuntu

sudo dpkg-reconfigure mysql-server-5.1