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

idea for reading encodign format

From: frank_lupo <frank_lupo(at)email(dot)it>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: idea for reading encodign format
Date: 2002-09-09 15:45:57
Message-ID: H26H4L$1ED5B9C74233397D69EA85867B59E720@email.it (view raw or flat)
Thread:
Lists: pgadmin-hackers
for reading encodign format current version is:
    'Load the Encoding Schemes
    cboProperties(0).Text = "SQL_ASCII"
    Set objItem = cboProperties(0).ComboItems.Add(, , "SQL_ASCII", "encoding", "encoding")
    objItem.Selected = True
   
    cboProperties(0).ComboItems.Add , , "EUC_JP", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "EUC_CN", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "EUC_KR", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "EUC_TW", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "UNICODE", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "MULE_INTERNAL", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "LATIN1", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "LATIN2", "encoding", "encoding"
    cboProperties(0).ComboItems.Add , , "LATIN3", "encoding", "encoding"

   cboPro
p
erties(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 encodign
For reading automatly encodign usign this code:
Dim rsSQL As New Recordset
Dim bIsValid As Boolean
    'Load the Encoding Schemes
    bIsValid = True
    X = 0
    While bIsValid
        Set rsSQL = frmMain.svr.Databases("template1").Execute("select pg_encoding_to_char(" & X & ")")
        If rsSQL.Fields(0).Value = "" Then bIsValid = False
        If bIsValid Then
            If X = 0 Then
                cboProperties(0).Text =
 rsSQL.Fi
e
lds(0).Value
                Set objItem = cboProperties(0).ComboItems.Add(, , rsSQL.Fields(0).Value, "encoding", "encoding")
                objItem.Selected = True
            Else
                cboProperties(0).ComboItems.Add , , rsSQL.Fields(0).Value, "encoding", "encoding"
            End If
        End If
        X = X + 1
    Wend

bye !!

Frank Lupo

Bye !!
Frank Lupo (Wolf) !!


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

Sponsor:
Tuffati in un mondo di occasioni d'oro...
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=612&d=9-9

pgadmin-hackers by date

Next:From: frank_lupoDate: 2002-09-09 15:47:37
Subject: idea for reading encodign format
Previous:From: frank_lupoDate: 2002-09-05 08:27:47
Subject: problem save db schema

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