Development Weblog

CREATE FUNCTION k_utf8_to_ent (bytea) RETURNS VARCHAR AS '
DECLARE
  mbs  INTEGER;
  ret  VARCHAR(8);
BEGIN
  mbs := octet_length($1);

  IF mbs=1 THEN
    ret:=''&#x''||to_hex(get_byte($1,0))||'';'';
  ELSIF mbs=2 THEN
    ret:=''&#x''|| to_hex(((get_byte($1,0)&31)*64)
    +(get_byte($1,1)&63))||'';'';
  ELSIF mbs=3 THEN
    ret:=''&#x''|| to_hex(((get_byte($1,0)&15)*64*64)
    +((get_byte($1,1)&63)*64)+(get_byte($1,2)&63))||'';'';
  END IF;

  RETURN ret;
END;
' LANGUAGE 'plpgsql';

CREATE FUNCTION k_utf8_to_html (VARCHAR) RETURNS VARCHAR AS '
DECLARE
  len  INTEGER;
  ret  VARCHAR(1024);
  utf  VARCHAR(8);
BEGIN
  CREATE CAST (text as bytea) WITHOUT FUNCTION;
  len := char_length($1);
  ret := '''';
  FOR i IN 1 .. len LOOP
    SELECT k_utf8_to_ent(CAST(substring($1 from i for 1) AS bytea))
    INTO utf;
    ret:=ret||utf;
  END LOOP;
  DROP CAST (text as bytea);
  RETURN ret;
END;
' LANGUAGE 'plpgsql';

  String [] files = new String[] {"addrbook/adrbkhome.jsp", "addrbook/editfellowtitle.jsp",...};



  com.knowgate.dfs.FileSystem oFS = new com.knowgate.dfs.FileSystem();


  
  String sBase = "/opt/knowgate/web-iso/";

  String sFile;


  
  int iFiles = files.length;


  
  for (int f=0; f<iFiles; f++) {

    sFile = oFS.readfilestr(sBase+files[f], "UTF-8");

    oFS.writefilestr(sBase+files[f], sFile, "ISO-8859-1");

  }

#!/bin/bash
for i in `grep "ο»Ώ" * -R | cut -f1 -d:` ; do 
cat $i | tr "ο»Ώ" ' ' > $i.new 
mv $i.new $i 
done

• new versions of JDBC drivers for Oracle 9.2, MSSQL 2000 SP1 and PostgreSQL 7.4 are redistributed instead of the old Oracle 8.0, MSSQL 2000 and PostgreSQL 7.3.
• savarese.oromatcher-1.1.0a.jar has been replaced with jakarta-oro-2.0.8.jar.
• enterprisedt.ftp-1.2.2.jar is now included inside hipergate.jar.
• new package org.webengruven.javaOTP for WebMail support

• WebMail (top priority).
• Newsgroups e-mail subscriptions management.
• Job Scheduler Java Thick client controller.

<!--
  <servlet-mapping>
    <servlet-name>invoker</servlet-name>
    <url-pattern>/servlet/*</url-pattern>
  </servlet-mapping>
-->

Topics