CHARACTER SET

Open Net Informática Ltda

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Parameter LANGDRIVER(BDE) / CHARACTER SET

I am using:
Oracle 8.0.4
Delphi 4.0

I created a simple table in Oracle and I created an index on a field
varchar2 of this table.

When I associated this table to a DBGrid and set indexName property of
component TTable for index that I had created on the field varchar2, the
data in DBGrid they were duplicated...

I think that this happens due to configuration of LANGDRIVER(BDE) to be
different from CHARACTER SET of Oracle.

My CHARACTER SET in Oracle is adjusted for WE8ISO8859P1.

When I change LANGDRIVER in BDE for (ascii ' ANSI') the problem stops
happening.

Would like to know if it is correct to leave this configuration in
LANGDRIVER of BDE?

Which is the best configuration for these parameters?

Note: I using accent of Portuguese Language

I thank any comment...

Fbio

John Pierc

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Parameter LANGDRIVER(BDE) / CHARACTER SET

I always use the ascii ansi driver. I had a sorting problem that was cured
by using it. We use Oracle 7.3.4.

John

"Open Net Informtica Ltda" wrote:

Quote

> I am using:
> Oracle 8.0.4
> Delphi 4.0

> I created a simple table in Oracle and I created an index on a field
> varchar2 of this table.

> When I associated this table to a DBGrid and set indexName property of
> component TTable for index that I had created on the field varchar2, the
> data in DBGrid they were duplicated...

> I think that this happens due to configuration of LANGDRIVER(BDE) to be
> different from CHARACTER SET of Oracle.

> My CHARACTER SET in Oracle is adjusted for WE8ISO8859P1.

> When I change LANGDRIVER in BDE for (ascii ' ANSI') the problem stops
> happening.

> Would like to know if it is correct to leave this configuration in
> LANGDRIVER of BDE?

> Which is the best configuration for these parameters?

> Note: I using accent of Portuguese Language

> I thank any comment...

> Fbio

Other Threads

1. How to set the LANGDRIVER parameter

2. changing BDE parameters (LangDriver, Block size)

3. Deploying BDE : Set the LANGDRIVER in InstallShield

4. Character set for eurosign/change the default character set

5. BDE And Interbase slow on international character sets

6. The GB Character Set for BDE

7. TIdTcpServer: How to set character by character mode.

8. Conecting with the BDE using UNICODE character sets

9. Cannot transliterate character between character sets

10. Cannot transliterate character between character sets.