UNICODE - PostgreSQL - Delphi7/Kylix3

aperger · Post by **aperger** » 21.07.2006, 01:00

Hi All,

I have a problem. I am planing to use UNICODE based PostgreSQL databases, but when I wanted to save text into a text-field I got error: byte sequence is not correct for encoding "UNICODE". Can anybody help me? Did I forget to convert latin2 -> utf8?

Under FC4-Linux/Kylix3 this happend with me too, but it looks better than on Win32, besause I can set in the environment what type of encoding what I use,... so I can save into the UNICODE db a normal TextBox content without conversion (latin2 -> utf8). But when I want to save an image into a BLOB field I got the same error message.

aperger · Post by **aperger** » 24.07.2006, 12:51

Hi Developers,

This is the Prepared statement (function TZEmulatedPreparedStatement.PrepareSQLQuery) from debug under Kylix 3. The last parameter whant to be an image (FSZLAEMBLEMA). how can I solve this problem?
Can anybody help?

Code: Select all

UPDATE TBEALLIT SET 
FCEGNEV = 'PergerSoft', 
FCEGORSZAG = 'Hungary', 
FCEGIRSZ = '8200', 
FCEGTELEP = 'Veszprem', 
FCEGUTCA = 'Boksa ter 3. 1. em 4.', 
FCEGTEL = '(36) 88 / 443643', 
FCEGFAX = '(36) 88 / 443643', 
FCEGEMAIL = 'pergerat@freemail.hu', 
FCEGBANKSZLA = '12345678-12345678-00000000', 
FCEGDEVIZASZLA1 = '-', 
FCEGDEVIZASZLA2 = '-', 
FCEGDEVIZASZLA3 = '-', 
FCEGADOSZAM = '1123456789-1-12', 
FDEFRAKTAR = 0, 
FDEFKTGH = 0, 
FDEFFIZHATARIDO = 0, 
FDEFFIZMOD = 'Ã

noelc · Post by **noelc** » 24.07.2006, 14:25

What is the PostgreSQL column type for FSZLAEMBLEMA?

aperger · Post by **aperger** » 24.07.2006, 16:16

Here is the stucture:

Code: Select all

CREATE TABLE tbeallit
(
  fcegnev varchar(100),
  fcegorszag varchar(100),
  fcegirsz varchar(70),
  fcegtelep varchar(100),
  fcegutca varchar(100),
  fcegtel varchar(70),
  fcegfax varchar(70),
  fcegemail varchar(100),
  fcegbankszla varchar(100),
  fcegdevizaszla1 varchar(100),
  fcegdevizaszla2 varchar(100),
  fcegdevizaszla3 varchar(100),
  fcegadoszam varchar(100),
  fdefraktar int4,
  fdefktgh int4,
  fdeffizhatarido int4,
  fdeffizmod varchar(70),
  fdefszamlamegjegyz varchar(255),
  fdefvalutaformat varchar(10),
  fdefarres float8,
  fido timestamp,
  fuser varchar(70),
  fszlaemblema bytea,
  fszlapeldany int4
)