Skip site navigation (1) Skip section navigation (2)

RE: idea for reading encodign format

From: frank_lupo <frank_lupo(at)email(dot)it>
To: dpage <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: RE: idea for reading encodign format
Date: 2002-09-11 06:12:13
Message-ID: H29FWD$0A279D589592BE21E807809036EAC8A1@email.it (view raw or flat)
Thread:
Lists: pgadmin-hackers
Is possible that the problem the vesrione of the compiler?  
My version 7.2 is compiled by GCC 2.95.3-5
Your version 7.2 is compiled by GCC egcs-2.91.66

Is a problem ?

OK,  any ideas on the problem I mentioned?
  
  -----Original Message-----
From: frank_lupo    [mailto:frank_lupo(at)email(dot)it] 
Sent: 10 September 2002    16:34
To: Dave Page
Cc: pgadmin-hackers
Subject:    Re: [pgadmin-hackers] idea for reading encodign format


  
I using  PostgreSQL 7.2
  
template1=# select    version();
                             version
------------------------------------------------------------
 PostgreSQL    7.2 on i686-pc-cygwin, compiled by GCC 2.95.3-5
(1 row)
  
       
I tried on 2  systems:
    
    
template1=# select       versin();
                                 version
---------------! --------- -      --------------
 --------
-
--------------
 PostgreSQL       7.3b1 on i686-pc-cygwin, compiled by GCC 2.95.3-5
(1 row)
    

    
template1=# select       pg_encoding_to_char(0)
template1-# union select       pg_encoding_to_char(1)
template1-# union select       pg_encoding_to_char(2)
template1-# union select       pg_encoding_to_char(3)
template1-# union select       pg_encoding_to_char(4)
template1-# union select       pg_encoding_to_char(5)
template1-# union select       pg_encoding_to_char(6)
template1-# union select       pg_encoding_to_char(7)
template1-# union select       pg_encoding_to_char(8)
template1-# union select       pg_encoding_to_char(9)
template1-# union select       pg_encoding_t! o_char(10 ) 
template1-# union select       pg_encoding_to_char(11)
template1-# union select       pg_encoding_to_char(12)
template1-# union select       pg_encoding_to_char(13)
template1-# union select
    pg_en
c
oding_to_char(14)
template1-# union select       pg_encoding_to_char(15)
template1-# union select       pg_encoding_to_char(16)
template1-# union select       pg_encoding_to_char(17)
template1-# union select       pg_encoding_to_char(18)
template1-# union select       pg_encoding_to_char(19)
template1-# union select       pg_encoding_to_char(20)
template1-# union select       pg_encoding_to_char(21);
 pg_encoding_to_char
---------------------
 EUC_CN
 EUC_JP
 EUC_KR
 EUC_TW
 JOHAB
 KOI8
 LATIN1
 LATIN10
 LATIN2
 LATIN3
 LATIN4
 LA!      TIN5
& n      bsp;LATIN6
 LATIN7
 LATIN8
 LATIN9
 MULE_INTERNAL
 SQL_ASCII
 TCVN
 UNICODE
 WIN1256
 WIN874
(22       rows)
    
    
and
    
    
template1=>  select       version();
                                    version
-----------------
 --------
-
-----------------------------------------
 PostgreSQL       7.2 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1!        ro w )
    

    
template1=>       select pg_encoding_to_char(0)
template1-> union select       pg_encoding_to_char(1)
template1-> union select       pg_encoding_to_char(2)
template1-> union select       pg_encoding_to_char(3)
template1-> union select       pg_encoding_to_char(4)
template1-> union select       pg_encoding_to_char(5)
template1-> union select       pg_encoding_to_char(6)
template1-> union select       pg_encoding_to_char(7)
template1-> union select       pg_encoding_to_char(8)
template1-> union select       pg_encoding_to_char(9)
template1-> union select       pg_encoding_to_char(10)
template1-> union select       pg_encoding_to_char(11)
template1-> union select&nb! sp;      pg_en c oding_to_char(12)
template1-> union select       pg_encodin
 g_to_cha
r
(13)
template1-> union select       pg_encoding_to_char(14)
template1-> union select       pg_encoding_to_char(15)
template1-> union select       pg_encoding_to_char(16)
template1-> union select       pg_encoding_to_char(17)
template1-> union select       pg_encoding_to_char(18)
template1-> union select       pg_encoding_to_char(19)
template1-> union select       pg_encoding_to_char(20)
template1-> union select       pg_encoding_to_char(21);
 pg_encoding_to_char
---------------------
 SQL_ASCII
(1       row)
    
    
The 7.2 system was ! ; compile d       without multibyte support. In 7.3, multibyte is always on. I guess       it probably doesn't matter much as it's obviously giving only useful encodings,       the problem is this (on the 7.2 system):
    
    
template1=>  select       pg_encoding_to_char(45);
 pg_encoding_to_char
---------------------
 SQL_ASCII

 (1

row)
    
    
template1=>  select       pg_encoding_to_char(450);
 pg_encoding_to_char
---------------------
 SQL_ASCII
(1       row)
0 D      
    
How would the loop       know when to give up and exit?
    
    
Regards,       Dave.
              
         -----Original Message-----
From: frank_lupo           [mailto:frank_lupo(at)email(dot)it] 
Sent: 10 September 2002           14:45
To: Dave Page
! Cc:         pgadmin-hackers
Subject:           RE: [pgadmin-hackers] idea for reading encodign format

      
          
          
I replace this code in frmdatabase pgadmin2. I don't have this problem.         
          
What is your result if you execute this selection ?
          
select pg_encoding_to_char(0) 
          
union select pg_encoding_to_char(1)
          
union select    pg_encoding_to_char(2)


0D
union select & nbsp;   pg_encoding_to_char(3)
          
union select    pg_encoding_to_char(4)
          
union select    pg_encoding_to_char(5)
          
union select    pg_encoding_to_char(6)
          
union select    pg_encoding_to_char(7)
          
union select    pg_encoding_to_char(8)
          
union select    pg_encoding_to_char(9)
          
union select    pg_encoding_to_char(10)
          
union select    pg_encoding_to_char(11)
          
union select    pg_encoding_to_char(12)
          
union select    pg_encoding_to_char(13)
          
union select    pg_encoding_to_char(14)
          
union select    pg_encoding_to_char(15)
          
union select           pg_encod! ing_to_ch a r(16)
          
union select    pg_encoding_to_char(17)
          
union select    pg_encoding_to_char(18)
          
 0Aunion
s
elect    pg_encoding_to_char(19)
          
union select    pg_encoding_to_char(20)
          
union select pg_encoding_to_char(21)
          
My result is :
          
 pg_encoding_to_char
---------------------
 ALT
 EUC_CN
 EUC_JP
 EUC_KR
 EUC_TW
 ISO_8859_5
 ISO_8859_6
 KOI8
 LATIN1
 LATIN10
 LATIN2
&n!        bsp;LATIN 3        
 LATIN4
 LATIN5
 LATIN6
 LATIN7
 LATIN8
 LATIN9
 MULE_INTERNAL
&!           nbsp;SQL_ A SCII
 UNICODE
 WIN
(22 rows)
          
The order is not by number encoding.
          

                       
Hi  Frank,
              
              
Hmm, that doesn't seem to work here. For any random integervalue of X             &nb! sp;  &          nbsp;that I try in select pg_encoding_to_char(X), I get SQL_ASCII as the                result.



 
              
This                is a problem I would like to fix, though I don't have time myself right now                :-(
              
              
Regards, Dave.< /          DIV>                                              
                    -----Original Message-----
From: frank_lupo                      [mailto:frank_lupo(at)email(dot)it] 
Sent: 09 September 2002                      16:46
To: pgadmin-hackers
Subject: [pgadmin-hackers] idea !                   ;  & n                   bsp;for reading encodign format

   &!            nbsp;&nbs p ;             
                      
for reading encodign format current                      version is:
                                 
    'Load the                      Encoding Schemes
    cboProperties(0).Text =                      "SQL_ASCII"
    Set objItem =                      cboProperties(0).ComboItems.Add(, , "S
 QL_ASCII
"
, "encoding",                      "encoding")
    objItem.Selected = True
 &n!            bsp;  ;                      
    cboProperties(0).ComboItems.Add , , "EUC_JP",                      "encoding", "encoding"
    cboProperties(0).ComboItems.Add ,                      , "EUC_CN", "e! ncoding", &                   nbsp;"encoding"
                         cboProperties(0).ComboItems.Add , , "EUC_KR", "encoding",                      "encoding"
    cboProperties(0).ComboItems.Add , , "EUC_TW",                      "encoding", "encoding"
    cboProperties(0).ComboItems.Add ,                    !  &nb s            p;, "UNICODE", "encoding", "encoding"
                         cboProperties(0).ComboItems.Add , , "MULE_INTERNAL", "encoding",                      "encoding"< BR>  ;    cboProperties(0).ComboItems.Add , ,                      "LATIN1", "encoding", "encoding"
                         cboProperties(0).ComboItems.Add , ,
  "LATIN2
"
, "encoding",                      "encoding"
    cboProperties(0).ComboItems.Add , , "LATIN3",                    &nb! sp;  "                   encoding", "encoding"
    cbo!            Propertie s (0).ComboItems.Add ,                      , "LATIN4", "encoding", "encoding"
                         cboProperties(0).ComboItems.Add , , "LATIN5", "encoding",                      "encoding"
    cboProperties(0).ComboItems.Add , , "KOI8",                      "encoding", "encoding"
    cboProperties(0).ComboItems.Add ,                      , "WIN", "encoding", "encoding"
                         cboProperties(0).ComboItems.Add , , "ALT", "encoding", "encoding"
                                 
this version is a problem to custom                      encodign into program. For new encodign modify program to add new                     &n! bsp;encod i gn
                                 
For reading automatly encodign
        u
s
ign this code : < /P>                                                     
Dim rsSQL As New Recordset
Dim                      bIsValid As Boolean
               &nbs! p; & n bsp;               
    'Load the                      Encoding Schemes
    bIsValid = True
    X                      = 0
    While                      bIsValid
        Set rsSQL =                      frmMain.svr.Databases("template1").Execute("select pg_encoding_to_char(" &                      X & ")")
        If                     &n! bsp;rsSQL .                   Fields(0).Value = "" T!            hen  b IsValid =                      False
        If bIsValid                      Then
            If                      X = 0                      Then
                                     cboProperties(0).Text =                      rsSQL.Fields(0).Value
                                     Set objItem = cboPropertie
 s (0).Co
m
b o Items.Add(, , rsSQL.Fields(0).Value,              &! nbsp;&nbs p            ;      "encoding",                      "encoding")
                                     objItem.Selected =                      True
     &nbs! p; &                   n bsp;                         Else
                                     cboProperties(0).ComboItems.Add , , rsSQL.Fields(0).Value, "encoding",                      "encoding"
                             &n! bsp;  ;              End If
        End                      If
        X = X +                      1
    Wend
                                 

                                 
bye !!
                                 

                                 
Frank Lupo
                                 


Bye !! ! Frank&nbs p            ;Lupo&n! bsp;(Wolf )                    !!                                   
----
Prend
 i GRATIS

l'email                      universale che... risparmia: clicca qui                      

Sponsor:
Tuffati in un mondo di occasioni d'oro...
Clicca qui 

          
          
                
                          &nb!                sp; < P>                
                        

                        

                        

                    

            
Bye !! Frank Lupo (Wolf) !!                                 
----
Prendi GRATIS l'email                   universa l              e che... risparmia: clicca qui                   

Sponsor:
Sei un webmaster, vuoi guadagnare? Affiliati ad                   Artefiori. Clicca qui!
Clicca qui  

            
          
Bye !! Frank Lupo        (Wolf) !!        
----
Prendi GRATIS l'email        universale che... risparmia: clicca        qui 

Spo
 nsor:
0AScopri la nuovissima stampante HP. Design        elegante, stampa veloce e di qualità! Scoprila qui!
Clicca qui    

Bye !!
Frank Lupo (Wolf) !!


--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Sconti fino al 20% per i magnifici bouquet di Artefiori! Clicca qui!
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=750&d=11-9

pgadmin-hackers by date

Next:From: frank_lupoDate: 2002-09-11 06:21:00
Subject: idea for exluding database not accessible (template0)
Previous:From: Dave PageDate: 2002-09-10 18:37:56
Subject: Re: idea for reading encodign format

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group