Re: [GENERAL] Mixed UTF8 / Latin1 database

2004-04-16 Thread Jean-Michel POURE
> I'm wondering if anyone could have a script or something to help me > with this situation... :( Knowing that Unicode is composed of plain ASCII characters, you may perform a conversion test using PHP "recode" function. You may test each record as follows: $test = recode ("latin1..u8", $record)

Re: [GENERAL] Converting timestamps and IP addresses

2004-02-11 Thread Jean-Michel POURE
Le Mercredi 11 Février 2004 12:12, Erwin Van de Velde a écrit : > If anyone has built such functions already, I'd gladly accept, and you can > win a line in my thank word ;-) Dear Erwin, I built a small centralised database built for Ulogd and ran into the same questions. You can either use impl

Re: [GENERAL] Open source data modeling tools for PostgreSQL

2003-11-27 Thread Jean-Michel POURE
Le Vendredi 21 Novembre 2003 15:04, Markus Seibold a écrit : > I am looking for an open source / free data modeling tool for PostgreSQL. Dear Markus, pgAdmin team was contacted lately by John McCawley <[EMAIL PROTECTED]> who is the developer of wxpgDesign, a very neat PostgreSQL design tool unde

Re: [GENERAL] Japanese and PostgreSQL

2003-11-20 Thread Jean-Michel POURE
Le Mercredi 19 Novembre 2003 06:10, Deibys Fernando Quintero a écrit : > it is the best solution for japanese characters ? You can use a Unicode database and pgAdmin3 client which supports UTF-8 Unicode: http://www.pgadmin.org Best regards, Jean-Michel ---(end of broadc

Re: [GENERAL] performance: time & disk access measurment

2003-11-10 Thread Jean-Michel POURE
Le Samedi 8 Novembre 2003 17:38, monu agrawal a écrit : > Is there any way in pgsql to measure that how much time a transaction has > taken & how many disk accesses it has performed. You can use pgAdmin3 (http://www.pgadmin.org) SQL editor for transaction time. Now, if you are using WAL with enou

Re: [GENERAL] Converting SQL-ASCII encoding database to UNICODE

2003-11-10 Thread Jean-Michel POURE
Le Dimanche 9 Novembre 2003 19:39, Rajesh Kumar Mallah a écrit : > If so what is the process The advantage of using a Unicode database is that UTF-8 supports/includes all known encodings at once. Therefore, in the process of development, it can help you save time. When using a Unicode database,

Re: [GENERAL] PostGreSql equivalents to mssql

2003-07-07 Thread Jean-Michel POURE
On Sunday 06 July 2003 08:44, [EMAIL PROTECTED] wrote: > >Migrating to PostGreSql, i need to know how capable pgsql Functions > >are , Vis a Vis SQLServer. can pgsql functions replace all > >functionality provided by Stored Procedures of MSSqlServer Dear Adivi, You may also have a loo

Re: [pgadmin-hackers] [GENERAL] pgAdmin III - Call for Translators

2003-07-04 Thread Jean-Michel POURE
French several years ago and noticed it was not an easy game. We share the same ideas. Please refer to (CVS is down at the moment) : http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/*checkout*/pgadmin3/docs/en_US/translation_guidelines.html Any suggestion is welcome. Cheers, Je